[Firebird-odbc-devel] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

Discussion:

Tiesheng Wu

2012-01-10 19:11:32 UTC

Dear colleagues,

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?

Kind regards,

Tee

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Tiesheng Wu

Computer Manager

Wolfson Institute of Preventive Medicine

Queen Mary, University of London

Charterhouse Square

London EC1M 6BQ

Tel: 020 7882 6285

Fax: 020 7882 6270

Email: <mailto:***@qmul.ac.uk <mailto:t.wu%40qmul.ac.uk> > ***@qmul.ac.uk
<mailto:t.wu%40qmul.ac.uk>

Web: <http://www.wolfson.qmul.ac.uk/> http://www.wolfson.qmul.ac.uk/

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

__._,_.___

Reply to
<mailto:***@qmul.ac.uk?subject=Re%3A%20ODBC%20connection%20to%20Firebird%20
%282%2E1%2E2%2E18118%29%20database%20on%20Windows%20Server%202003%20from%20W
indows%207%20x64> sender | Reply to
<mailto:firebird-***@yahoogroups.com?subject=Re%3A%20ODBC%20connection%2
0to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windows%20Server%
202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyOGJoc3VrBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5MQ
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI2NDQ-?act=reply&messageNum=116491>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlNGdtNGw3BF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjY0NA--> Start a New Topic

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
bm5iczZ1BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI2NDQEdHBjSWQDMTE2NDkx>
(1)

Recent Activity:

.
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmanIxMGV
xBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI2NDQ-?o=6> New Members 10

<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlNmtoaGg4BF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjY0NA--> Visit Your Group

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15olu3vms/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229844/L=cbbe3360-3bbe-11e1-bb
fd-9bd994106983/B=uiZ0AWKJiUY-/J=1326222644641320/K=LhXmRKRnUGhqLz.AETPQsg/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj>

<http://groups.yahoo.com/;_ylc=X3oDMTJkODBuNG1oBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNjQ0>
Yahoo! Groups

Switch to:
<mailto:firebird-support-***@yahoogroups.com?subject=Change%20Delive
ry%20Format:%20Traditional> Text-Only,
<mailto:firebird-support-***@yahoogroups.com?subject=Email%20Delivery:%20
Digest> Daily Digest .
<mailto:firebird-support-***@yahoogroups.com?subject=Unsubscribe>
Unsubscribe . <http://docs.yahoo.com/info/terms/> Terms of Use

.

<http://geo.yahoo.com/serv?s=97359714/grpId=2442406/grpspId=1705115386/msgId
=116491/stime=1326222644/nc1=4025338/nc2=5741391/nc3=3848640>

__,_._,___

Alexander Potapchenko

2012-01-10 20:28:33 UTC

Permalink

Post by Tiesheng Wu
Dear colleagues,
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?
Kind regards,
Tee

It depends on what application (32 or 64 bit) will use ODBC driver.
Windows doesn't matter.

--
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru

Tiesheng Wu

2012-01-10 19:30:28 UTC

Permalink

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

Post by Tiesheng Wu
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/

__._,_.___

Reply to
<mailto:***@iblogmanager.com?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20
connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windo
ws%20Server%202003%20from%20Windows%207%20x64> sender | Reply to
<mailto:firebird-***@yahoogroups.com?subject=Re%3A%20%5Bfirebird-support
%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database
%20on%20Windows%20Server%202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyb2hxZ3FjBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5Mg
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI3OTY-?act=reply&messageNum=116492>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlazBjcjJvBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjc5Ng--> Start a New Topic

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
aGhvZW03BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI3OTYEdHBjSWQDMTE2NDkx>
(2)

Recent Activity:

·
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmOWJiODR
uBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI3OTY-?o=6> New Members 10

<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZ3E0MzliBF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjc5Ng--> Visit Your Group

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15obclrni/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229996/L=265f1e1a-3bbf-11e1-9c
eb-7b121b790cc2/B=12N1AdBDRvA-/J=1326222796720389/K=pMjnYcp5C2IO2aCIsSvxQA/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj>

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

Switch to:
<mailto:firebird-support-***@yahoogroups.com?subject=Change%20Delive
ry%20Format:%20Traditional> Text-Only,
<mailto:firebird-support-***@yahoogroups.com?subject=Email%20Delivery:%20
Digest> Daily Digest
<mailto:firebird-support-***@yahoogroups.com?subject=Unsubscribe>
Unsubscribe <http://docs.yahoo.com/info/terms/> Terms of Use

.

<http://geo.yahoo.com/serv?s=97359714/grpId=2442406/grpspId=1705115386/msgId
=116492/stime=1326222796/nc1=5898817/nc2=4025373/nc3=3848644>

__,_._,___

Sadek Alaoui

2012-01-10 19:38:47 UTC

Permalink

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

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****
** **
*Sent:* 10 January 2012 19:13
*Subject:* Re: [firebird-support] ODBC connection to Firebird
(2.1.2.18118) database on Windows Server 2003 from Windows 7 x64****
** **
****

Post by Tiesheng Wu
We try to connect a Firebird (2.1.2.18118) database on Windows Server

2003

Post by Tiesheng Wu
(32 bit) from Windows 7 x64.
Which ODBC (version, x32 or x64) should we use?

Tiesheng Wu

2012-01-10 19:50:59 UTC

Permalink

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:***@gmail.com]
Sent: 10 January 2012 19:39
To: firebird-odbc-***@lists.sourceforge.net
Cc: firebird-***@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 <***@qmul.ac.uk>

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

Post by Tiesheng Wu
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/

__._,_.___

Reply to
<mailto:***@iblogmanager.com?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20
connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windo
ws%20Server%202003%20from%20Windows%207%20x64> sender | Reply to
<mailto:firebird-***@yahoogroups.com?subject=Re%3A%20%5Bfirebird-support
%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database
%20on%20Windows%20Server%202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyb2hxZ3FjBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5Mg
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI3OTY-?act=reply&messageNum=116492>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlazBjcjJvBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjc5Ng--> Start a New Topic

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
aGhvZW03BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI3OTYEdHBjSWQDMTE2NDkx>
(2)

Recent Activity:

·
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmOWJiODR
uBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI3OTY-?o=6> New Members 10

<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZ3E0MzliBF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjc5Ng--> Visit Your Group

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15obclrni/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229996/L=265f1e1a-3bbf-11e1-9c
eb-7b121b790cc2/B=12N1AdBDRvA-/J=1326222796720389/K=pMjnYcp5C2IO2aCIsSvxQA/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj>

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

<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
Switch to: Text-Only, Daily Digest Unsubscribe Terms of Use

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

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

<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
__,_._,___

<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-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

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

Michael Möhle

2012-01-11 08:22:38 UTC

Permalink

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:***@qmul.ac.uk]
Sent: Tuesday, January 10, 2012 8:51 PM
To: ***@gmail.com
Cc: 'M Joomun'; firebird-***@yahoogroups.com;
firebird-odbc-***@lists.sourceforge.net
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:***@gmail.com]
Sent: 10 January 2012 19:39
To: firebird-odbc-***@lists.sourceforge.net
Cc: firebird-***@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 <***@qmul.ac.uk>

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

Post by Tiesheng Wu
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/

__._,_.___

Reply to
<mailto:***@iblogmanager.com?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20
connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windo
ws%20Server%202003%20from%20Windows%207%20x64> sender | Reply to
<mailto:firebird-***@yahoogroups.com?subject=Re%3A%20%5Bfirebird-support
%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database
%20on%20Windows%20Server%202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyb2hxZ3FjBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5Mg
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI3OTY-?act=reply&messageNum=116492>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlazBjcjJvBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjc5Ng--> Start a New Topic

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
aGhvZW03BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI3OTYEdHBjSWQDMTE2NDkx>
(2)

Recent Activity:

·
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmOWJiODR
uBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI3OTY-?o=6> New Members 10

<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZ3E0MzliBF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjc5Ng--> Visit Your Group

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15obclrni/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229996/L=265f1e1a-3bbf-11e1-9c
eb-7b121b790cc2/B=12N1AdBDRvA-/J=1326222796720389/K=pMjnYcp5C2IO2aCIsSvxQA/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj>

<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
Switch to: Text-Only, Daily Digest Unsubscribe Terms of Use

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

<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
__,_._,___

<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

Tiesheng Wu

2012-01-15 21:53:59 UTC

Permalink

Dear All,

We have now solved the problem about running Firebird 64-bit ODBC on Windows
7 x64 by installing the Firebird 64-bit Server onto the PC running Windows 7
x64.

This is because Firebird 64-bit ODBC requires gds32.dll to be available.

We can run 32-bit application properly on Windows 7 x64 now.

Thank you very much for your kind help on this.

Kind regards,

Tee

From: Tiesheng Wu [mailto:***@qmul.ac.uk]
Sent: 10 January 2012 19:51
To: ***@gmail.com
Cc: 'M Joomun'; firebird-***@yahoogroups.com;
firebird-odbc-***@lists.sourceforge.net
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:***@gmail.com]
Sent: 10 January 2012 19:39
To: firebird-odbc-***@lists.sourceforge.net
Cc: firebird-***@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 <***@qmul.ac.uk>

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

Post by Tiesheng Wu
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/

__._,_.___

Reply to
<mailto:***@iblogmanager.com?subject=Re%3A%20%5Bfirebird-support%5D%20ODBC%20
connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database%20on%20Windo
ws%20Server%202003%20from%20Windows%207%20x64> sender | Reply to
<mailto:firebird-***@yahoogroups.com?subject=Re%3A%20%5Bfirebird-support
%5D%20ODBC%20connection%20to%20Firebird%20%282%2E1%2E2%2E18118%29%20database
%20on%20Windows%20Server%202003%20from%20Windows%207%20x64> group | Reply
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJyb2hxZ3FjBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExNjQ5Mg
RzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMjYyMjI3OTY-?act=reply&messageNum=116492>
via web post |
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlazBjcjJvBF
9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2
50cGMEc3RpbWUDMTMyNjIyMjc5Ng--> Start a New Topic

Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/116491;_ylc=X3oDMTM4
aGhvZW03BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lk
AzExNjQ5MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMjYyMjI3OTYEdHBjSWQDMTE2NDkx>
(2)

Recent Activity:

·
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmOWJiODR
uBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2x
rA3ZtYnJzBHN0aW1lAzEzMjYyMjI3OTY-?o=6> New Members 10

<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlZ3E0MzliBF9TAzk
3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHA
Ec3RpbWUDMTMyNjIyMjc5Ng--> Visit Your Group

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get
the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15obclrni/M=493064.14543979.14562481.132984
30/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1326229996/L=265f1e1a-3bbf-11e1-9c
eb-7b121b790cc2/B=12N1AdBDRvA-/J=1326222796720389/K=pMjnYcp5C2IO2aCIsSvxQA/A
=6060255/R=0/SIG=1194m4keh/*http:/us.toolbar.yahoo.com/?.cpdl=grpj>

<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
Switch to: Text-Only, Daily Digest Unsubscribe Terms of Use

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

<http://groups.yahoo.com/;_ylc=X3oDMTJkbWE5dTMxBF9TAzk3MzU5NzE0BGdycElkAzI0N
DI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzI2MjIyNzk2>
__,_._,___

<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