Wich from LCL to use for work with Firebird

[finalist]

I would like to work with Firebird Database.
Wich components to use ?
Thank you !

[hallenberger]

Hello!

I use the uib-components in Lazarus and Delphi. Works fine.

http://www.progdigy.com/?page_id=5

[Arbee]

The SQLDB component works fine with Firebird.  Comes bundled with Lazarus, although I think it is not pre-installed.

The free ZEOS package works too.  If you're using FB 2.5 then you should use the 7.0.0 release in that case.  FB2.1 and earlier work with versions 7.0.0 and 6.6.

[finalist]

Thank you.
I see, there are SQLdb and Zeos Access components, waiting for me to use them
Everithing will be o.k. I suppose.

[finalist]

At Design-Time:
1. IBConnection, fill-up the properties
IBConnection.Connected := True; - I see it is True
2. SQLTransaction.Active := True; - ( Automatic is True )
Problem:
3. SQLQuery.Active := True; - but it does not become as True (becomes back as False)
DeleteSQL := 'DELETE FROM PLAYERS WHERE PLAYER = :PLAYER';
InsertSQL := 'INSERT INTO PLAYERS VALUES
(:PLAYER,
 :TEAM,
 :FROM_YEAR,
 :TO_YEAR,
 :MATCHES,
 :GOALS)';
UpdateSQL := 'UPDATE PLAYERS SET
(TEAM = :TEAM,
 FROM_YEAR = :FROM_YEAR,
 TO_YEAR = :TO_YEAR,
 MATCHES = :MATCHES,
 GOALS = :GOALS)
WHERE PLAYER = :PLAYER';
I don't understand the reason for that behavior.
Can anybody help me about this problem ?
Thank you !

[Zoran]

I assume that in SQL property you have "SELECT * FROM PLAYERS".

First, does it work if you remove code from DeleteSQL, InsertSQL and UpdateSQL properties? Can you set SQLQuery.Active?

[finalist]

SQL is set to "SELECT * FROM PLAYERS"
I Can not set SQLQuery.Active to True;

After I removed code from DeleteSQL, InsertSQL and UpdateSQL properties, SQLQuery.Active can not be set to True.

( I can open Database using IBExpert, I can see data into Table PLAYERS, I can see information about Database is Server version 2.1 (Firebird) )

[Arbee]

You don't get any error message when you try to open the query?

have you tried doing it programmatically (like coding a "SQLQUERY.OPEN" in - for instance - the form's onCreate event).  No error then?

By the way ... what platform and Lazarus/FPC are we talking here?

[marcov]

Did you copy the FB client DLL to the application directory?

[finalist]

I don't get any error message when I try to open the query.
I tried doing it programmatically by:

Code: [Select]

procedure TForm_Firebird.FormCreate(Sender: TObject);
begin
  DBFolder := ExtractFilePath(Application.ExeName) + 'DB';

  IBConnection.DatabaseName := DBFolder + '\SCORERERS.FDB';
  Edit.Text := DBFolder + '\SCORERERS.FDB';
  IBConnection.HostName := '';  // 'localhost';
  IBConnection.UserName := 'SYSDBA';
  IBConnection.Password := 'masterkey';
  IBConnection.Connected := True;
  SQLQuery.Active := True;
  (*
  ZConnection.Database := DBFolder + '\SCORERERS.FDB';
  ZConnection.HostName := '';
  ZConnection.User := 'SYSDBA';
  ZConnection.Password := 'masterkey';
  ZConnection.Connected := True;
  *)
end;The behavior I describe is under 64 bits Windows 7.
I have installed Code Typhon Center ver.1.20 for Win64, but I have 2  options:
1. Lazarus for Win64;
2. Lazarus for Win32 (Active) ver.0.9.29;
I have Free Pascal ver.1.0.12 2010.12.30;
Both are installed under Code Typhon.
The reason I did install Code Typhon is, I could not install Lazarus under Windows 7 ( at the end of 2010 year ).

( I have 32 bits Windows XP installed on another partition on the same PC. Yesterday I did try to compile and start without success the same programm code, there was error message, but I forgot it ).

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 ).

[Arbee]

You are using FB embedded by the looks of it?

Have you also tried storing the DLL in the Windows directory?
(I guess it still exists in W7 ... personally I still trail behind on XP)

[finalist]

I don't use FB embedded.
I have Firebird_2_1 installed.
Before a minutes:
1. I did copy fbclient.dll from C:\Program Files (x86)\Firebird\Firebird_2_1 to the Desktop;
2. Made fbclientD.dll as a copy of fbclient.dll;
3. Copy both fbclientD.dll and fbclient.dll into:
3.1. Database directory, test with the program = without success;
3.2. Application directory, test with the program = without success;
3.3. Windows\ directory, test with the program = without success;
3.4. Windows\System32\ directory, test with the program = without success;

[Arbee]

But if you do not use FB Embedded, you should fill the hostname with 'localhost'.

Leaving the hostname empty will persuade SqlDb to try and use FB embedded.  An that requires some more DLL files than just a client dll.

[Arbee]

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.

[finalist]

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.