DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trying to create an oracle linked server on SQL server 2008 R2

1000795Apr 3 2013 — edited May 19 2013

We are trying to create a linked server to the oracle database on our SQL server 2008 R2 instance. We have created a DSN on the server hosting the SQL Server instance using the oracle 11g odbc driver. When we 'Test connection' on the DSN it is successful. When I try to create a linked server, it connects to the DSN correctly (if I entered the wrong DSN it returns the error 'Data source name not found and no default driver specified') but then it fails with:

The OLE DB provider "MSDASQL" for linked server "OracleSrv" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "OracleSrv".
OLE DB provider "MSDASQL" for linked server "OracleSrv" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "OracleSrv" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "OracleSrv" returned message "[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
". (Microsoft SQL Server, Error: 7399)

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2013

Added on Apr 3 2013

#odbc, #oracle, #sql, #windows-and-net

1 comment

3,220 views