32 bit ODBC connection on 64 bit machine

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

32 bit ODBC connection on 64 bit machine

Peter Barrett

Hello,

 

I am trying to make a connection between MS Access 2010 32 bit and a Firebird database(Fishbowl Inventory) using ODBC. I am running Windows 7 Home Premium ver. 6.17601 SP 1 on a 64 bit machine. I have installed both the 32 bit and 64 bit Firebird/Interbase® ODBC drivers ver. 2.00.00.151. I can successfully connect to the database with a system DSN using the 64 bit driver. I cannot make a connection with the 32 bit driver which I believe I need to use with MS Access 32 bit. Any ideas? Would migrating to MS Office 64 bit work?

 

Thanks.

 

Peter


------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
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: 32 bit ODBC connection on 64 bit machine

Alexander Potapchenko-2
On 02.09.2011 15:59, Peter Barrett wrote:

Hello,

 

I am trying to make a connection between MS Access 2010 32 bit and a Firebird database(Fishbowl Inventory) using ODBC. I am running Windows 7 Home Premium ver. 6.17601 SP 1 on a 64 bit machine. I have installed both the 32 bit and 64 bit Firebird/Interbase® ODBC drivers ver. 2.00.00.151. I can successfully connect to the database with a system DSN using the 64 bit driver. I cannot make a connection with the 32 bit driver which I believe I need to use with MS Access 32 bit. Any ideas? Would migrating to MS Office 64 bit work?

 

Thanks.

 

Peter


Hi,

32-bit ODBC driver requires the 32-bit firebird client (fbclient.dll). Do you have this client version on your computer?

Alexander
--
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru

------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
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: 32 bit ODBC connection on 64 bit machine

Peter Barrett

No. The client is 64-bit (fbclient64.dll)

 

 

Peter

 

From: Alexander Potapchenko [mailto:[hidden email]]
Sent: Friday, September 02, 2011 8:20 AM
To: [hidden email]
Subject: Re: [Firebird-odbc-devel] 32 bit ODBC connection on 64 bit machine

 

On 02.09.2011 15:59, Peter Barrett wrote:

Hello,

 

I am trying to make a connection between MS Access 2010 32 bit and a Firebird database(Fishbowl Inventory) using ODBC. I am running Windows 7 Home Premium ver. 6.17601 SP 1 on a 64 bit machine. I have installed both the 32 bit and 64 bit Firebird/Interbase® ODBC drivers ver. 2.00.00.151. I can successfully connect to the database with a system DSN using the 64 bit driver. I cannot make a connection with the 32 bit driver which I believe I need to use with MS Access 32 bit. Any ideas? Would migrating to MS Office 64 bit work?

 

Thanks.

 

Peter

 

Hi,

32-bit ODBC driver requires the 32-bit firebird client (fbclient.dll). Do you have this client version on your computer?

Alexander

--

Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru


------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel