Installation Order for Windows 64 Bit – 32 Bit ODBC App:

- Install Firebird Native Client 32 Bit by installing the Firebird
Server on this System and choosing “Only Client Install”

- Install Firebird ODBC Driver 32 Bit

- Go to Control Panel. There must be a Button “32-Bit Control
Panel”. Use the ODBC Manager from there.

- Setup your connection



Regards Michael



From: Tiesheng Wu [mailto:t.wu@...]
Sent: Tuesday, January 10, 2012 8:51 PM
To: sadek.alaoui@...
Cc: 'M Joomun'; firebird-support@yahoogroups.com;
firebird-odbc-devel@...
Subject: [Firebird-odbc-devel] FW: [firebird-support] ODBC connection to
Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64



Dear Sadek,



Could you please let me know how to use the Firebird ADO.net provider?



We have to get the database connection working soon.



Kind regards,



Tee



From: Sadek Alaoui [mailto:sadek.alaoui@...]
Sent: 10 January 2012 19:39
To: firebird-odbc-devel@...
Cc: firebird-support@yahoogroups.com; M Joomun
Subject: Re: [Firebird-odbc-devel] [firebird-support] ODBC connection to
Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64



I had many issues with Firebird ODBC, especially when the OS is 64 bit.

The only workaround I found, is to use the Firebird ADO.net provider and not
the ODBC

Best regards,
Sadek



2012/1/10 Tiesheng Wu <t.wu@...>

Dear Thomas,



Thanks a lot for your message. The application is 32 bit.



First I tried 64bit ODBC driver (2.0.0.151) on Windows 7 x64. The driver was
installed properly. Then I configured the ODBC connection via Control Panel
à Administrative tool à Data Source (ODBC). When I tried connection test it
gave the error message “sqlcode-904 fbcode 335544375 – Unable to connect to
data source: library ‘gds32.dll’ failed to load”.



I then removed the 64bit ODBC driver and installed 32bit ODBC driver
(2.0.0.151). The driver was installed properly. However it did not show up
in the ODBC Data Source Administrator using Control Panel à Administrative
tool à Data Source (ODBC). Therefore I did not know where and how I should
configure the ODBC connection.



Kind regards,



Tee



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] ODBC connection to Firebird (2.1.2.18118)
database on Windows Server 2003 from Windows 7 x64

> We try to connect a Firebird (2.1.2.18118) database on Windows Server 2003
> (32 bit) from Windows 7 x64.
>
>
>
> Which ODBC (version, x32 or x64) should we use?

This depends on your client application and not on your server. If your
client application is 32-bit then the 32-bit ODBC driver, otherwise 64-bit.

--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/




<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>

----------------------------------------------------------------------------
--
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



[Non-text portions of this message have been removed]