For anyone who can help. I receive the following error when running a query.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server " " 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 " ".
i.item_no, -- Character Field
x.ref_item_no -- Character Field
INNER JOIN .TABLEB X
ON I.EDP_NO = X.EDP_NO
When running the query, I begin to see Management Studio return results. Then, for some unknown reason, it fails with the above error. I have searched around on the error, but not much on Google, Microsoft, or Oracle. It is interesting, sometimes the query returns 9K rows, sometimes 20K, and sometimes 50K, or by chance just a few hundred. The results are random each time before the failure.
I have other queries running that work fine without issue. This ONE query seems to be causing me problems.
Windows 2003 R2 x64
SQL Server 2005 SP2
Oracle Client 10.2.0.2.20
Windows Clustering (Active/Passive)
DataCenter of SQL Server: AZ
DataCenter of Linked Server (Oracle): Oregon
I have set the "Allow in Process" for the Oracle Provider, with no luck. Keep in mind, other queries using the same Linked Server works perfectly fine. Some take longer and return more data, but the other queries return successfully.
Have any of you ran into this issue? I am tempted to reinstall the Oracle clients with the latest OLEDB drivers to see if we can get it working.
Please help if you have seen this before. We are supposed to go live with some reports that call stored procedures which use a single Oracle Linked Server this weekend.
I forgot to mention, i have tried both 4-part names or OpenQuery with no luck.