Oracle Database Discussions

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!

OLE DB provider "MSDAORA" for linked server "" returned message "ORA-06413: Connection not open. ".

ASulthanNov 15 2014 — edited Nov 18 2014

Hi,

I am using Windows 2003 server and Sqlserver 2005 by the use of Linked server , I made a connection to Oracle 10g after that I am importing records from Oracle to sqlserver 2005. When I made tnsnames.ora in sql machine , it worked fine but when i am using tnsnames file from oracle server then i fiired importing procedure it returns below maintain error :

OLE DB provider "MSDAORA" for linked server "TESTJED" returned message "ORA-06413: Connection not open.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "TESTJED".

Any help highly appreciated

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2014

Added on Nov 15 2014

#heterogeneous-connectivity

2 comments

1,421 views