Re: [Firebird-odbc-devel] Using the ODBC Driver on Vista 64

[Werner F. B. <wer...@fr...>]

Kevin,

Kevin Preston wrote:
> HI,
...
> 
> ERROR [08004] [ODBC Firebird Driver]Unable to connect to data source: 
> library 'gds32.dll' failed to load
> 
>  
> 
> There is a gds32.dll file in the system32 folder (version 6.0.1.0) and 
> also one in the sysWOW64 (version 6.3.5.13206)
> 
>  
I would make sure to point ODBC to the Firebird client library, either 
using the Windows Datasource admin tool or by setting it using your 
installer (e.g. InnoSetup), i.e.:

; ODBC entries
Root: HKLM; SubKey: Software\ODBC\ODBC.INI\ODBC Data Sources; ValueType: 
string; ValueName: YourDataSourceName; ValueData: Firebird/InterBase(r) 
driver; Flags: createvalueifdoesntexist uninsdeletevalue
Root: HKLM; SubKey: Software\ODBC\ODBC.INI\YourDataSourceName; Flags: 
createvalueifdoesntexist uninsdeletevalue; ValueName: Driver; ValueType: 
string; ValueData: C:\WINDOWS\System32\OdbcFb32.dll
Root: HKLM; SubKey: Software\ODBC\ODBC.INI\YourDataSourceName; Flags: 
createvalueifdoesntexist uninsdeletevalue; ValueName: Dbname; ValueType: 
string; ValueData: {code:GetDataDir}\twcb.fdb
Root: HKLM; SubKey: Software\ODBC\ODBC.INI\YourDataSourceName; Flags: 
createvalueifdoesntexist uninsdeletevalue; ValueName: Client; ValueType: 
string; ValueData: {app}\prog\fbclient.dll

The last line sets the client library.

You might want to manually set it using the datasource admin tool and 
then extract all the HKLM entries and then adjust your installer.

Note sure this will correct all your problems, but at least you use a 
more up to date client.


Werner