Perform the following steps to obtain and install the ODBC driver. From the Oracle web site, download the following files: Oracle instant client (instantclient-basic-win32-11.2.0.1.0.zip). At the University, installing the Oracle client and ODBC driver is basically a four or five step process: 1. Download the Oracle installation file. Decompress (i.e., unzip) the Oracle installation file. Optional: Run the Oracle Universal Installer to “uninstall” an earlier version of the Oracle client. To install the ODBC driver, you need administrator-level privileges so that the driver can be installed in the C: Program Files directory. Visual C Redistributable for Visual Studio 2015 ¶ To use Snowflake ODBC Driver in a Windows environment, you have to first install Visual C Redistributable for Visual Studio 2015.
It is ridiculously difficult and ambiguous how you’re supposed to get the Oracle ODBC driver installed on your Windows machine. It’s certainly not a simple task. Well, since I figured it out today I thought I would document it.
Step 1: Install the ODBC Driver¶ If you haven’t already downloaded the latest driver version, download it now. For details, see Downloading the ODBC Driver. Double-click on the downloaded.msi file. By default, Windows 10 does not shipped with Oracle ODBC connection utility. In other word, I was unable to connect to my Oracle database from MS Access. Installing Oracle ODBC Driver on Windows 10 is a bit tricky. It’s not as simple as installing PostgreSQL ODBC driver or MySQL ODBC Driver. I was struggling to get it works.
