Recent

Author Topic: Wich from LCL to use for work with Firebird  (Read 19960 times)

Zoran

  • Hero Member
  • *****
  • Posts: 1653
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: Wich from LCL to use for work with Firebird
« Reply #15 on: April 11, 2011, 10:02:02 pm »
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.
« Last Edit: April 11, 2011, 10:04:47 pm by Zoran »

Zoran

  • Hero Member
  • *****
  • Posts: 1653
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: Wich from LCL to use for work with Firebird
« Reply #16 on: April 11, 2011, 10:03:23 pm »
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

  • Hero Member
  • *****
  • Posts: 1653
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: Wich from LCL to use for work with Firebird
« Reply #17 on: April 11, 2011, 10:14:08 pm »
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

  • Jr. Member
  • **
  • Posts: 84
Re: Wich from LCL to use for work with Firebird
« Reply #18 on: April 11, 2011, 10:58:17 pm »
It is terribly strange ..
I will test this code under Linux Ubuntu 10.04.

finalist

  • Jr. Member
  • **
  • Posts: 84
Re: Wich from LCL to use for work with Firebird
« Reply #19 on: April 12, 2011, 09:42:19 am »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 9090
  • FPC developer.
Re: Wich from LCL to use for work with Firebird
« Reply #20 on: April 12, 2011, 10:24:09 am »
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

  • Hero Member
  • *****
  • Posts: 2112
    • Additional info
Re: Wich from LCL to use for work with Firebird
« Reply #21 on: April 12, 2011, 11:45:01 am »
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?
ct2laz - Conversion between Lazarus and CodeTyphon
bithelpers - Bit manipulation for standard types
pasettimino - Siemens S7 PLC lib

finalist

  • Jr. Member
  • **
  • Posts: 84
Re: Wich from LCL to use for work with Firebird
« Reply #22 on: April 12, 2011, 11:50:50 am »
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

  • Hero Member
  • *****
  • Posts: 2112
    • Additional info
Re: Wich from LCL to use for work with Firebird
« Reply #23 on: April 13, 2011, 08:45:19 am »
ct2laz - Conversion between Lazarus and CodeTyphon
bithelpers - Bit manipulation for standard types
pasettimino - Siemens S7 PLC lib


finalist

  • Jr. Member
  • **
  • Posts: 84
Re: Wich from LCL to use for work with Firebird
« Reply #25 on: April 13, 2011, 10:48:27 pm »
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 :)

 

TinyPortal © 2005-2018