MSSQL want to link to the server read the ORACLE, the same configuration, in ORCALE loading MSSQL server connection is normal, but the client error:

Unable to initialize the link server "ORMS" OLE DB access interface "OraOLEDB. Oracle data source object,"
Link Server "ORMS" OLE DB access interface "OraOLEDB. Oracle" returned message "ORA - 12560: TNS: protocol adapter error", Microsoft SQL Server, an error: (7303)

Internet really can't find the way to... A great god grant instruction,

CodePudding user response:

The client need to configure the good tnsnames. Ora file,

CodePudding user response:

The software is a 64 - bit?

CodePudding user response:

MSSQL end installation orakcle oralce software, then configure link to TNS oralce, MSQLL configuration to use good configuration TNS service name, can connect

CodePudding user response:

Detailed reference: http://blog.csdn.net/jiaowu_wei/article/details/78482431