Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Establish 32-bit ODBC connection to 64-bit Oracle 11g database

leighelliott78Jan 20 2010 — edited Dec 18 2010

Hi Everyone,

Just to set the scene:

PC with Windows 2003 server x64 OS installed, Oracle 11g 11.1.0.7 64-bit installed and MS Office 2007 installed.

I am looking for advice on the best way to establish an ODBC link so that MS Access 2007 (32-bit) can connect to the Oracle 11g (64-bit) database.

There are known issues, see [http://support.microsoft.com/kb/942976|http://support.microsoft.com/kb/942976] (which I have hit) when attempting to use a 64-bit ODBC DSN within MS Access 2007. This means that I need to setup and install an Oracle 11g 32-bit ODBC driver to be used against the Oracle 11g database (TNS listener also running 64-bit).

Any thoughts on the best approach I should take to do this?

Regards,
Leigh.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2011

Added on Jan 20 2010

#general-database-discussions

6 comments

5,552 views