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.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2014-11-25 : 01:04:58
|
| hi allI 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 1The 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 1Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "XXXXx".if anybody knows pls explain for the resolutionmohan |
|
|
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. |
 |
|
|
|
|
|
linked Sever Issue in MSSQl