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. Thank you.
