I don't have an answer for you.
If I were in your situation, then at the very least I would:
- check if the query runs without errors when submitted directly to Oracle
- somehow find out if the latest ODBC/Oracle driver is on the server
- experiment with the Provider (ODBC vs Oracle provider) of the linked server
- rule out network connection/instability problems
- if you also have a newer SQL Server running somewhere: try it from there, and see if it makes a difference
Good luck.
Gert-Jan
No comments:
Post a Comment