pae2
asked on
SQL2016 to ORACLE11G linked-server
I'm creating a SQL Server linked-server between SQL Server 2016 64BIT and ORACLE-11G Release 11.2.0.4.0 64BIT. After following the instructions that I have found, here's what I did:
01. downloaded & installed the Oracle Client: Version 11.2.0.4.0 from http://www.oracle.com/technetwork/topics/winx64soft-089540.html:
* it just extracted files onto the hard disk; there was no executable that I could find
* a and b below are what I ended up extracting to the hard-disk on the SQL Server / WIN 2012R2 Server
a. Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
* http://download.oracle.com/otn/nt/instantclient/11204/instantclient-basic-windows.x64-11.2.0.4.0.zip
b. Instant Client Package - ODBC: Additional libraries for enabling ODBC applications
* http://download.oracle.com/otn/nt/instantclient/11204/instantclient-odbc-windows.x64-11.2.0.4.0.zip
02. added the following arg to the PATH ENV VAR on the WIN 2012R2 Server hosting SQL Server: 'C:\Program Files\oracle-instantclient -basic-win dows.x64-1 1.2.0.4.0\ instantcli ent_11_2'.
The OraOLEDB.Oracle Provider is not showing in SQL Server. What am I missing?
Thanks so much for the help!
pae2
01. downloaded & installed the Oracle Client: Version 11.2.0.4.0 from http://www.oracle.com/technetwork/topics/winx64soft-089540.html:
* it just extracted files onto the hard disk; there was no executable that I could find
* a and b below are what I ended up extracting to the hard-disk on the SQL Server / WIN 2012R2 Server
a. Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
* http://download.oracle.com/otn/nt/instantclient/11204/instantclient-basic-windows.x64-11.2.0.4.0.zip
b. Instant Client Package - ODBC: Additional libraries for enabling ODBC applications
* http://download.oracle.com/otn/nt/instantclient/11204/instantclient-odbc-windows.x64-11.2.0.4.0.zip
02. added the following arg to the PATH ENV VAR on the WIN 2012R2 Server hosting SQL Server: 'C:\Program Files\oracle-instantclient
The OraOLEDB.Oracle Provider is not showing in SQL Server. What am I missing?
Thanks so much for the help!
pae2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problem. Glad to help.