Devart Forums

Hi,

Im having trouble trying to connect to the FB-DB(Firebird - Database) using the dbexpida40.dll driver. This is my Configuration:

objConn.ConnectionName := 'InterBase';
objConn.LibraryName := 'dbexpida40.dll';
objConn.VendorLib := 'fbClient.dll';
objConn.GetDriverFunc := 'getSQLDriverInterBase';
objConn.DriverName := 'InterBase';
objConn.Params.Values['Database'] := 'fds.fdb';
objConn.Params.Values['User_Name'] := 'SYSDBA';
objConn.Params.Values['Password'] := 'masterkey';

I was able to connect using the dbxoodbc.dll driver. This is my Configuration (under the ODBC driver):

objConn.ConnectionName := 'OpenOdbc:Prompt';
objConn.LibraryName := 'dbxoodbc.dll';
objConn.DriverName := 'OpenOdbc';
objConn.GetDriverFunc := 'getSQLDriverODBCW';
objConn.VendorLib := 'ODBCJDBC.DLL';
objConn.Params.Values['Database'] := 'FDS-DB';
objConn.Params.Values['DriverName'] := 'OpenOdbc';
objConn.Params.Values['User_Name'] := 'SYSDBA';
objConn.Params.Values['Password'] := 'masterkey';

Im using Windows 7 x32, Delphi 2007, and Firebird 2.0

Thanks!

Hello,

You should use the following code:

Even with the new code Im not able to connect, its very weird... Anyways Im going to keep looking for a solution....

I solved the problem adding the drivername as a parameter (objConn.Params.Values['DriverName'] := 'DevartInterBase';)... without this parameter Im unable to connect....

objConn.ConnectionName := 'Devart InterBase';
objConn.DriverName := 'DevartInterBase';
objConn.GetDriverFunc := 'getSQLDriverInterBase';
objConn.LibraryName := 'dbexpida40.dll';
objConn.VendorLib := 'fbclient.dll';
objConn.Params.Values['Database'] := 'fds.fdb';
objConn.Params.Values['User_Name'] := 'SYSDBA';
objConn.Params.Values['Password'] := 'masterkey';
objConn.Params.Values['DriverName'] := 'DevartInterBase';

SOLVED!!!!!


THANKS!