|Subject||Unable to get Firebird ODBC driver working in 64-bit|
Hello, and thank you for taking the time to consider this problem.
I am trying to develop a simple reporting script in perl. I've done this many times using the ODBC driver for SQL Server with good results.
One of our vendors uses a captive or embedded Firebird database, and I am trying to get an ODBC driver working on the server so I can run my script.
From the best I can tell, the Firebird client is 32-bit, though I'm not sure. I found a fbclient.dll in C:\Program Files (x86)\Firebird\Firebird_2_1\bin\ and copied it to WINDOWS\system32\ and renamed it to gds32.dll.
The server (where I'm trying to get the script running) is Windows Server 2008 R2 SP1 64-bit. Because it's a server and supported by the vendor, I can't mess with the Firebird DB installation.
I am in ODBC driver hell.
I have tried the Firebird 32- and 64-bit ODBC drivers, tried installing something from Interbase that didn't work at all, and in desperation I tried a driver kit from Easysoft. Right now I have the Firebird Win32 driver installed.
Right now I am getting "Specified driver could not be loaded due to system error 193: (Firebird/Interbase(r) driver, C:\Windows\system32\OdbcFb.dll)."
It seems it's finding the driver files but the driver won't work with the client(gds32 or fbclient)
Any helpful suggestions would be appreciated.