Re: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

Tiesheng 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: [hidden email] [mailto:[hidden email]] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: [hidden email]
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/

__._,_.___

Recent Activity:

·         New Members 10

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

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

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

.

__,_._,___


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|

Re: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

sadek
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 <[hidden email]>

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: [hidden email] [mailto:[hidden email]] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: [hidden email]
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/

__._,_.___

Recent Activity:

·         New Members 10

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

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

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

.

__,_._,___


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|

FW: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

Tiesheng Wu

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:[hidden email]]
Sent: 10 January 2012 19:39
To: [hidden email]
Cc: [hidden email]; 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 <[hidden email]>

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: [hidden email] [mailto:[hidden email]] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: [hidden email]
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/

__._,_.___

Recent Activity:

·         New Members 10

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

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

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


------------------------------------------------------------------------------
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

 


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Untitled attachment 00156.txt (360 bytes) Download Attachment
Untitled attachment 00159.txt (192 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: FW: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

Michael Möhle

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:[hidden email]]
Sent: Tuesday, January 10, 2012 8:51 PM
To: [hidden email]
C
c: 'M Joomun'; [hidden email]; [hidden email]
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 [hidden email]
Sent: 10 January 2012 19:39
To: [hidden email]
Cc: [hidden email]; 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 <[hidden email]>

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: [hidden email] [mailto:[hidden email]] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: [hidden email]
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/

__._,_.___

Recent Activity:

·         New Members 10

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

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

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


------------------------------------------------------------------------------
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


------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|

Re: FW: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

Tiesheng Wu
In reply to this post by Tiesheng Wu

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:[hidden email]]
Sent: 10 January 2012 19:51
To: [hidden email]
Cc: 'M Joomun'; [hidden email]; [hidden email]
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 [hidden email]
Sent: 10 January 2012 19:39
To: [hidden email]
Cc: [hidden email]; 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 <[hidden email]>

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: [hidden email] [mailto:[hidden email]] On Behalf Of Thomas Steinmaurer
Sent: 10 January 2012 19:13
To: [hidden email]
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/

__._,_.___

Recent Activity:

·         New Members 10

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

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

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


------------------------------------------------------------------------------
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


------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel