Subject Re: [firebird-support] ODBC connection: 'gds32.dll' failed to load
Author Mark Rotteveel
Windows 64 bits has two(!) ODBC managers, the one you can easily access is the 64 bit variant, the other one you need to locate yourself (I believe in the SysWOW64 folder). As far as I know the Firebird ODBC driver is only 32 bits, so you will need to configure it using the 32 bits ODBC manager.

The problem could also be that your application is 64 bits, it is impossible for a 64 bit application to directly use a 32 bit ODBC driver (Windows does not allow 64 bit programs to load 32 bit drivers, DLLs and such).

Yet another cause could be that the SysWOW64 folder does not contain the gds32.dll: confusingly onder Windows 64 the System32 folder contains the 64 bit DLLs and the SysWOW64 contains the 32 bit DLLs that are in System32 on a 32bit system. Also make sure you use the 32 bit variant of fbclient.dll as the gds32.dll.

My advice: if you can, avoid using ODBC, especially on 64 bit Windows.

Mark

> Hi!
>
> This is a "connection failure via ODBC"-issue, I hope I've chosen the
> appropriate group.
>
> A windows service of mine, which is running on a Windows Server 2003 R2
> (64-bit) and connecting to a remote Firebird database via ODBC, is throwing
> the following error since I installed a newer version of my service:
>
> ERROR [08004] [ODBC Firebird Driver] Unable to connect to data source:
> library 'gds32.dll' failed to load
>
> It's stunning that the way I'm connecting to the Firebird database did not
> change in the newer version of my service. I'm (still) using the
> Firebird_ODBC_2.0.0.148 driver and DB-Version 1.5.5.4926-3. My connection string
> (still) is:
> DRIVER={Firebird/InterBase(r)
> driver};DSN=WIEN;DATABASE=SERVER:WIEN;UID=USER;PWD=****
> (I've created an alias named WIEN)
> In ODBC driver manager, when I test the dsn, I also get the above error.
>
> I've tried to take the fbclient.dll of the Firebird server, rename it to
> gds32.dll and copy it into the System32 and System-directories of the
> Windows 2003 server. Unfortunately that didn't help.
> The "instclient q g" command gives the following output:
> "Installed GDS32.DLL version : 6.3.5.4926 (shared DLL count 2)"
>
> Any recommendations are highly appreciated!
> Thanks a lot,
> Anne
--
Aufgepasst: Sind Ihre Daten beim Online-Banking auch optimal gesch├╝tzt?
Jetzt absichern: https://homebanking.gmx.net/?mc=mail@...