CODEWITHSUNDEEP
oracle-databaseexcelodbcvba
Mike Shanahan
Mike Shanahan

Reputation: 239

Proper Oracle ODBC Driver Installation on 32 bit Windows 7

I am using an Excel VBA application to connect to an Oracle 12c database.
Excel is 2010, 32 bit, in Windows 7.

Many have advised Oracle Instant Client, but this has not worked for me. The installation requires a number of configuration steps that I cannot perform due to administrative restrictions on my workstation.

However, I have installed the ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (12.2.0.1.0), available HERE. This package includes the Oracle ODBC driver which works for my application. However, it contains several other components that I do not need, and throws some errors during installation that are disconcerting.

Can anyone tell me which of the following components I actually need to select in order to get the ODBC Driver?

ODAC Options

Since I cannot get InstantClient to work with my companies restrictions, I'm now aiming to use this package, but hopefully to slim it down to just the component I need. I'm doing trial and error, but it's messy. The installation takes a long time and there's no uninstaller, so I have to manually delete the files after installation.

Thanks for any help you can provide!

Upvotes: 0

Views: 2332

Answers (2)

Younes El-karama
Younes El-karama

Reputation: 189

Get the full 32-bit Oracle client installer (not the ODAC) from here:

http://download.oracle.com/otn/nt/oracle12c/122010/win32_12201_client.zip

Do an silent install using this reponse file (edit as needed and save as client_install_32.rsp in the same directory as setup.exe)

Response file

setup.exe" ORACLE_HOME_NAME=OracleClient12201x32 -waitforcompletion -nowait -silent -responseFile client_install_32.rsp

The key config entry is this:

oracle.install.client.customComponents="oracle.rdbms.oci:12.2.0.1.0","oracle.network.client:12.2.0.1.0","oracle.odbc:12.2.0.1.0"

Upvotes: 0

Wernfried Domscheit
Wernfried Domscheit

Reputation: 59436

The smallest solution is to download the

Instant Client Package - ODBC: Additional libraries for enabling ODBC applications (instantclient-odbc-nt-12.2.0.1.0-2.zip)

from Instant Client Downloads for Microsoft Windows 32-bit

You can also download the ODAC with Oracle Developer Tools for Visual Studio from ODAC Developer Downloads - Oracle Universal Installer

Upvotes: 1

Related Questions