Hi there, I have a SQL Server 2008 (not R2) database and a linked server that is a UniData 71 database.
When I test the connection it passes.
But when I try to execute any query, I get the following message back:
Cannot fetch a row from OLE DB provider “IBM.UniOLEDB” for linked server “MyServer”
This is the query:
SELECT * FROM
ORDER BY KEY_ID’
I wasn’t able to find anything too useful when googling the error message, has anyone here seen this before?