Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 linked Sever Issue in MSSQl

Author  Topic 

kond.mohan
Posting Yak Master

213 Posts

Posted - 2014-11-25 : 01:04:58
hi all

I have created linked server to load the Data from oracle to MSSQL sever.query is Partially(1102 rows) Executing and throwing below Error.

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "XXXXX" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "XXXXx".

if anybody knows pls explain for the resolution


mohan

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-25 : 09:31:25
Try to run the query directly on the ORACLE server and see what you get.
Go to Top of Page
   

- Advertisement -