Unable to Find Server (Timeout error)

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for InterBase & Firebird in Delphi and C++Builder
Post Reply
Rufino
Posts: 3
Joined: Fri 15 Jul 2011 06:02

Unable to Find Server (Timeout error)

Post by 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!

AndreyZ

Post by 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;

Rufino
Posts: 3
Joined: Fri 15 Jul 2011 06:02

Unable to connec

Post by 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

Post by 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!

Post Reply