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.