Making progress
Tom Sinski, March 02, 2017 - 5:22 pm UTC
I installed instant client version 11.0.6.0. Now my errors are:
Setting up a File DSN or User DSN or System DSN using Microsoft ODBC for Oracle driver. Error:
The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of Oracle version 7.3 (or greater) client software installation
Setting up a User DSN not as adminstrator using Oracle instant client driver.
Error:
12170: TNS: Connection timeout occurred. (#12170) [Microsoft][ODBC driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC driver Manager] Driver's SQLSetconnectAttr failed (#0)
Setting up a System DSN as adminstrator using Oracle instant client driver:
Error:
Unable to connect
SQL State=S1000
[Oracle][ODBC][Ora] ORA-12170: TNS: Connect timeout occurred
Follow up question
Tom Sinski, March 02, 2017 - 5:24 pm UTC
Do I need to install the full Oracle client to use the Microsoft ODCB for Oracle driver (driver: MSORCL32.dll)? Or should it work with just installing Oracle Instant Client?
March 03, 2017 - 5:30 am UTC
Instant client will be fine, but see the next review as well
Yes, it is Possible...
J. Laurindo Chiappa, March 02, 2017 - 6:55 pm UTC
According to the official instant client page (ie,
http://www.oracle.com/technetwork/database/features/oci/odbc-ic-releasenotes-094306.html ) the procedure for using ODBC with Instant Client on Windows is :
1. Install the Instant Client Basic or Basic Lite package, as described above.
2. Unzip the Instant Client ODBC package.
3. Execute odbc_install.exe from the Instant Client directory. If Instant Client is 11g or lower, start the command prompt with the Administrator privilege.
So YES, you can connect via ODBC using Instant Client, ** but ** another package (the "Instant Client ODBC package") is required : download and install this package, too, besides the Instant Client itself.
Regards,
J. Laurindo Chiappa
March 03, 2017 - 5:29 am UTC
THanks for your input.
Create an Microsoft ODBC drivers for Oracle
Marc Guvenc, October 06, 2017 - 7:39 pm UTC
I created the Microsoft ODBC drivers for Oracle this way,
1. Find the table in MS Access not in Oracle (make sure all the column names and table names are Upper Case)
2. Right click > Export > ODBC Databases
3. Click OK
4. Click on the "Machine Data Source" tab
5. Click the New button
6. Click the radio button "User Data Sources"
7. Click the "Next >" button
8. Scroll down until you see the "Microsoft ODBC for Oracle" driver
9. Select it and click the "Next >" button
10. Add all the credentials and this will create driver and add it your Data Sources going forward