Wich from LCL to use for work with Firebird

[Zoran]

What I forgot to mention...

I think for IBConnection the DLL must be renamed to gds32.dll.  It is the old name for the Interbase DLL.

I don't think so. I think fbclient.dll is okay with IBConnection.

But, after I installed FB-64bit on Win7, I had to execute something from command line and only then the fbclient.dll was installed to correct "system" folder (there seems to be more than one "system"-like folder on 64-bit Win7).

Open command line, somewhere under your fb folder, iirc you can find a folder named like 64 something, Execute what is there with correct parameters.

I can't tell you exactly what it was, now I don't have 64 bit windows here.
Tommorow morning, at work, I'll see and post here what it actually is.

[Zoran]

Unfortunately I did change HostName to 'localhost', but it was not raise opening of SQLQuery.
May be I need to fill again DeleteSQL, InsertSQL and ModifySQL properties of the SQLQuery.

No. You surely don't need those for opening a select query. Let's better take one step at a time.

[Zoran]

Now I remembered that you said that you don't have a problem to connect the IBConnection component, so I'd say there is no problem with client dll. You have the problem to open the query. Strange...

[finalist]

It is terribly strange ..
I will test this code under Linux Ubuntu 10.04.

[finalist]

The behavior of the same components under Lazarus is different :
When I try at Design-time to connect IBConnection, I get an Error mrssage: 'Can not load default Firebird clients ("libgds.so" or "libfbclient.so"). Check your installation'
( I did copy libfbclient.so into the Application folder, but it raises the same error-message .. )

[marcov]

What I forgot to mention...

I think for IBConnection the DLL must be renamed to gds32.dll.  It is the old name for the Interbase DLL.

I don't think so. I think fbclient.dll is okay with IBConnection.

With modern versions (2.4.x series used by 0.9.30) of Lazarus/FPC it is. Don't know about years old versions like 2.2.4.
 

[avra]

I have installed Code Typhon Center ver.1.20 for Win64

Do you know that there is CodeTyphon 1.50?

I did not copy the FB client DLL to the application directory, I did copy it to the Database directory (may be it is my mistake).

Do you have any SQL manager os some other independent software that can successfully browse your FB tables?

[finalist]

I have installed Code Typhon Center ver.1.20 for Win64

Do you know that there is CodeTyphon 1.50?

I did not copy the FB client DLL to the application directory, I did copy it to the Database directory (may be it is my mistake).

Do you have any SQL manager os some other independent software that can successfully browse your FB tables?

I will be very happy to work with CodeTyphon 1.50. I will be thankful about a link to download it.

I have IBExpert manager, I can browse my FB tables, I see information posted in the tables, there is no problem.

[avra]

I will be very happy to work with CodeTyphon 1.50. I will be thankful about a link to download it.

http://www.pilotlogic.com/sitejoom/index.php?option=com_content&view=article&id=96&catid=68&Itemid=147

[finalist]

....
http://www.pilotlogic.com/sitejoom/index.php?option=com_content&view=article&id=96&catid=68&Itemid=147

Tnak you very much !

[finalist]

I did install CodeTyphon 1.50.
My terrible application did not work again.
But I did decide to install CodeTyphon 1.50 on my old computer.
I did it and I did create a totally new simple application using the same SQLdb components for work with Firebird database.
I did create a new Firebird database.
It was a happy Idea, because it was successful at Design-time, it was successful later at Run-time.
Then I did copy this happy Application on my current Computer.
It was a successful test.
So, I don't know what is the reason, but now I can work with CodeTyphon 1.50 and SQLdb components connected to Firebird database.
Thank you very much everybody