Aug 29, 2011. New Windows 7 Enterprise x64 workstation with a bunch of 64-bit Oracle software, I also needed connectivity to Oracle from various 32-bit software. So, I downloaded and installed the latest and greatest 32-bit Oracle11g instant client (11.2. Hyperprism DX Pack V2.5 more. 0.2.0) from OTN with all the goodies, including ODBC driver that I. Devart ODBC Driver for Oracle provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, macOS, Linux, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your.

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. Bhs Manual. Any help would be greatly appreciated. I downloaded and installed the package listed here, which includes 64 Bit Oracle ODBC Drivers: I then opened the ODBCAD32 file in C: Windows System32 odbcad32.exe. Under USER DSN, I clicked Add, Selected Oracle in OraClient 12Home3, and hit finish. I then added the connection information which I received from IT and used 'Test Connection' which gave me a successful. In Microsoft Access 2010, I selected 'ODBC Database' from the External Data Ribbon, Linked to Data source, and selected the Machine Data source DSN – Dec 17 '13 at 14:08.

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. I am on Windows 7, 64 Bit. Using Access 64 Bit. Just download these 2 files.

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