Skip to Main Content

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!

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracl

763982Dec 21 2010 — edited Dec 23 2010
I have created a linked server in a SQL Server 2005 connecting to either an Oracle Database and a SQL Server 6.5 database and getting the following error for both links when trying to query using provider OraOLEDB.Oracle, please help.

OLE DB provider "OraOLEDB.Oracle" for linked server "finprod3" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "finprod3".

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 20 2011
Added on Dec 21 2010
1 comment
3,756 views