If you install 32-bit ODBC driver, you’ll need to use 32-bit ODBC administration panel – run odbcad32.exe from c:\windows\SysWOW64. This is because you use 64-bit ODBC administration panel. That’s the problem I also had – ODBC driver didn’t appear in ODBC data source. You don’t have instant_client_11 on the list. So, right now we can configure ODBC connection: choose Control Panel, then Administrative Tools, then Data Sources (ODBC), then System DNS and then Add, on the list, choose instant_client_11, then Finish and then in the configuration window… wait. Oracle ODBC Driver is installed successfully. When successfully, you should get the following info: Next, open the command line (Run as administrator) and go to the folder where you unzip ODBC driver, in my case: Then add the TNS_ADMIN environment variable indicating the path to the tnsnames.ora file (in my PC it is c:\oracle\11.2.0\CLIENT\network\admin): The DSN will be used to identify the data source uniquely. Data Source Name: Specify the data source name.
You can specify the following options in the dialog box. A dialog box named Oracle ODBC Driver Configuration opens.
Generally, you choose ODBC driver version based on tool version, that you use to get data from Oracle database.Īnyway, both downloaded files, you need to unzip to THE SAME folder (for example: c:\oracle\instant_client_11), then add the folder to the PATH environment variable: Select Oracle in OraDB19Home1 from the list of data sources listed in Create New Data Source dialog box. So in my situation I had to choose 32-bit ODBC driver. I have on my PC: Windows 7 – 64-bit version, 64-bit Oracle client already installed but MS Office in 32-bit version. Well, I think the best way to answer this question is to describe my situation. Which version to choose – 32-bit or 64-bit? – here is the link for Instant Client Downloads for Microsoft Windows (圆4), for ODBC, you need instantclient-basic-windows.圆4-11.2.0.3.0.zip and instantclient-odbc-windows.圆4-11.2.0.3.0.zip files (Oracle 11.2.0.3 version) – here is the link for Instant Client Downloads for Microsoft Windows (32-bit), for ODBC, you need instantclient-basic-nt-11.2.0.3.0.zip and instantclient-odbc-nt-11.2.0.3.0.zip files (Oracle 11.2.0.3 version)
Here is a step-by-step instruction how to install the ODBC driver.įirst of all, you need to download proper files: Installation of the ODBC driver in Windows 7 is quite simple but there are a few tricks better to know.