CODEWITHSUNDEEP
ms-accessoracle11godbc
user3109283
user3109283

Reputation: 11

ODBC Connect to Oracle 64bit from MS Access (Using System32\odbcad32.exe)

I need to connect to a 64 bit Oracle server via ODBC in Microsoft Access. I have installed the 64 Bit ODBC drivers and set up the DSN using the System32\odbcad32 file.

The registry is pointing the driver towards:

C:\app\erahn\product\12.1.0\client_3\SQORA32.DLL

I cannot validate online that SQORA32.DLL is the 64 bit driver; the install package was the 64 bit version so I am assuming that it is.

I did not have luck connecting to the server using the 32 bit drivers either (Test connection would not work), so I am at as loss for what could be holding me back.

Any help would be greatly appreciated.

Eric

Upvotes: 1

Views: 27967

Answers (1)

ihightower
ihightower

Reputation: 3253

I made it work... after 100s of attempts looking everywhere.. This may be of no use to someone.. but if all else fails for you... try it.

I am on Windows 7, 64 Bit.. using Access 64 Bit..

just download these 2 files... from http://www.oracle.com/technetwork/topics/winx64soft-089540.html

Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications Download instantclient-basic-windows.x64-11.2.0.2.0.zip (53,669,935 bytes)

*Instant Client Package - ODBC: Additional libraries for enabling ODBC applications Download instantclient-odbc-windows.x64-11.2.0.2.0.zip (1,356,558 bytes)

Remember download only 11.2.0.2.0 (for me all other version did not work and had numerous issues).

then follow directions from here:

http://celemotan.wordpress.com/2008/10/22/instantclient/

Upvotes: 4

Related Questions