Unable to Find Server (Timeout error)

Unable to Find Server (Timeout error)

Postby Rufino » Fri 15 Jul 2011 06:16

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!
Rufino
 
Posts: 3
Joined: Fri 15 Jul 2011 06:02

Postby AndreyZ » Fri 15 Jul 2011 11:25

Hello,

You should use the following code:
Code: Select all
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.LoginPrompt := false;
objConn.Open;
AndreyZ
 

Unable to connec

Postby Rufino » Sat 16 Jul 2011 05:28

:( Even with the new code Im not able to connect, its very weird... Anyways Im going to keep looking for a solution....
Rufino
 
Posts: 3
Joined: Fri 15 Jul 2011 06:02

FIXED

Postby Rufino » Mon 18 Jul 2011 03:21

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!
Rufino
 
Posts: 3
Joined: Fri 15 Jul 2011 06:02


Return to dbExpress driver for InterBase & Firebird