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!
Unable to Find Server (Timeout error)
Hello,
You should use the following code:
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;
Unable to connec
Even with the new code Im not able to connect, its very weird... Anyways Im going to keep looking for a solution....
FIXED
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!
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!