Tiburon: VCL DB Unicode Application with InterBase 2007

Everybody is talking about Tiburon (the next Delphi Version) and the new Unicode Support. Today i play for you with the Unicode Support and Interbase 2007. So let us quick build a InterBase Database and a Browser in Unicode.

 

First i create a new database in the InterBase with the following Script. I use in this example the ServerCharSet UTF8.

/******************************************************************************/

/*            Generated            2008.02.19 17.07.2008 16:21:29            */

/******************************************************************************/

SET SQL DIALECT 3;

SET NAMES UTF8;

CREATE DATABASE ‘YourIpOurComputerName:C:\unicode_data.ib’

USER ‘SYSDBA’ PASSWORD ‘masterkey’

PAGE_SIZE 8192

DEFAULT CHARACTER SET UTF8;

/******************************************************************************/

/*                                   Tables                                   */

/******************************************************************************/

CREATE TABLE TBL_TEST (

    ID    INTEGER NOT NULL,

    TEXT  VARCHAR(100)

);

 

/******************************************************************************/

/*                                Primary Keys                                */

/******************************************************************************/

 

ALTER TABLE TBL_TEST ADD CONSTRAINT PK_TBL_TEST PRIMARY KEY (ID);

 

 

After this i create in Tiburon a new VCL Application.

 

 

 

 

 

 

After this i create a new shortcut in the Datanbase Manager

 

 

 

 

 

Give a Name for the new InterBase Connection

 

 

 

Modify the Connection for the Parameters

 

 

 

 

 

Cause we like to use Interbase with DBXpress we add in the uses are the Unit DBXInterbase.

 

 

Now we are adding on the TForm:

-          SQLConnection

-          SimpleDataSet

-          DataSource

-          DBNavigator

-          DBGrid

 

 

 

 

On SQLConnection we change in the Objecinspector the Properties

-          ConnectionName -> MyUnicode

-          add in Params the servercharset UTF8

-          set LoginPromt to False (if you like)

 

 

 

On your SimpleDataSet1 change the Properties:

-          SQLConnection to your SQLConnection1

-          DataSet->CommandText to select * from TBL_TEST

-          Active-> True

 

 

Change also

-          DataSource1: DataSet -> SimpleDataSet1

-          DBNavigator1 & DBGrid 1: DataSource -> DataSource1

 

To automatic update  to the InterBase Database add in the SimpleDataSet1 Event OnPost the following code:

 

 

Now let us save all, compile and start:

 

 

Ok let’s add some text. To get some fun characters (unicode) you can start the windows Program CharMap

 

 

 

 

 

You see the VCL works fine with the Combination Unicode and InterBase 2007.

 

Great Works CodeGear!!!

 

Regards Daniel Magin.

 

 

 

Part 2: Installing InterBase 2007 on suse and opensuse 11

On some Machines i found out the Running (also command line) registration after using the install did not work. I get the error:

./LicenseManagerLauncher.sh -i Console
/opt/interbase/bin/LicenseManagerLauncher: error while loading shared libraries: libstdc++-libc6.2-2.so.3: cannot open shared object file: No such file or directory

to run the LicenseMangerLauncher you must install a package from your suse cd.

1. Start Yast (the Configuration Tool from Suse)

2. Select “Install or Remove Software” (or a little other cause i use a German Version)

2.  Select in the left Pane “Software”

3. Search in Filter for “compat”

4. Insall Package

Screenshot

That’s all and the Registration Tool can be run as JavaApp with
/opt/interbase/bin/LicenseManagerLauncher.sh

or as Console Application with
LicenseManagerLauncher.sh -i Console

Screenshot

Regards Daniel Magin

Installing InterBase 2007 on suse and opensuse 11

hi all,

i tried out to install the interbase 2007 server on the new opensuse 11. so i get some problems to run it correct. i found out how to run now correct and i like to share to you, and i hope you save more time as me. (if it helps you, please add a thanx to the comments).

1. install normal the (open)suse 11

2. login as root

3. run install_linux.sh from your InterBase 2007 cd or folder

4. now use the registration wizard to add you key

5. now you have to change some things to run InterBase 2007 correct as service

• ln -s /opt/interbase/lib/libgds.so.0 /usr/lib/libgds.so
  to create a link in the correct folder

• if you now (do not!) try to run the ibmgr you get the error message
  

  “/opt/interbase/bin/ibmgr.bin: error while loading shared libraries: libdl.so.2: cannot open shared object file: No such file or directory”

  to fix this:
  edit /opt/interbase/bin/ibmgr and comment out or delete the lines that export the LD_ASSUME_KERNEL variable.

• if you now (do not!) try to run the ibmgr you get in the interbase.log the error message:
  “SERVER/process_packet: connection rejected for root”
  This error occurs because the server tries to initiate a local connection via localhost and isn’t a trusted host.You just need to make sure localhost is a trusted host. One way you can do this is by adding localhost to the /etc/hosts.equiv file.

  for more information about this see this LINK

• now you can start the server as a service like:
  ./ibmgr -start -forever

I am not a professional linux guy, perhaps there are better ways. But now the best DataBase Server of the world is running on my opensuse 11.

I hope it helps, greetings from Germany and best regards

Daniel Magin

Embarcadero Technologies Closes Acquisition of CodeGear™

The deal is now finished.

You can find now on the codegear website the embarcadero logo(s).

Also all the DatabBase Products from Embarcadero will now be under the brand DataBaseGear.

Embarcadero has published a press release:

Embarcadero Technologies Closes Acquisition of CodeGear™

Abstract: Embarcadero Technologies Closes Acquisition of CodeGear™

SAN FRANCISCO – July 1, 2008 – Embarcadero Technologies, a privately-held company of Thoma Cressey Bravo, completed the acquisition of CodeGear from Borland Software Corporation (NASDAQ: BORL) for approximately $24.5 million on June 30. CodeGear is being integrated into Embarcadero Technologies, which will continue to operate as a private company under the leadership of current Embarcadero CEO Wayne Williams.

As a result of this acquisition, Embarcadero is expected to operate with more than $100 million in annual revenue and over 500 employees worldwide. The company will serve more than three million application developers and database professionals with tools that are interoperable, integrated and that interconnect these two communities in new ways.

“The acquisition of CodeGear enables Embarcadero to expand into new strategic markets and offer a complete product portfolio for users to design, build and run software applications in the environment they choose,” said Orlando Bravo, managing partner of Thoma Cressey Bravo.

Embarcadero will support CodeGear’s customers and partners and will evolve and deepen the functionality of CodeGear’s existing product lines. Embarcadero’s professional database tools will be marketed under the DatabaseGear™ brand, and its application developer tools will be encompassed under the CodeGear™ brand.

“Given the synergistic talent and technologies, we anticipate a successful integration process that quickly leverages CodeGear’s strengths and results in a powerful, unified organization,” added Holden Spaht, principal of Thoma Cressey Bravo.

About Embarcadero Technologies
Embarcadero Technologies Inc. empowers application developers and database professionals with tools to design, build and run software applications in the environment they choose. A community of more than three million worldwide and 90 of the Fortune 100 rely on Embarcadero’s CodeGear™ and DatabaseGear™ product lines to increase productivity, openly collaborate and be free to innovate. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the globe. Embarcadero is online at www.embarcadero.com.

About Thoma Cressey Bravo
Thoma Cressey Bravo is a leading private equity investment firm that has been providing equity and strategic support to experienced management teams building growing companies for more than 27 years. The firm originated the concept of “industry consolidation” or “build and buy” investing, which seeks to create value through the strategic use of acquisitions to accelerate business growth. Through a series of private equity funds, Thoma Cressey Bravo currently manages approximately $2.0 billion of equity capital. In the software industry, Thoma Cressey Bravo has completed 35 acquisitions across 12 platform companies with total annual earnings in excess of $500 million. For more information on Thoma Cressey Bravo, visit http://www.tcb.com.

# # #

Embarcadero, the Embarcadero Technologies logos and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.

regards

Daniel Magin