Products Resources Support About Us

SQL Server 2008 - Unidata connection error

unidata

#1

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
OPENQUERY (MyServer,
‘SELECT KEY_ID,
CUST_CODE
FROM SHIP_HDR
ORDER BY KEY_ID’
)

I wasn’t able to find anything too useful when googling the error message, has anyone here seen this before?

Thank you


#2

There are a number of knowledge base articles on the Rocket Customer Portal about setting up and trouble shooting the Linked Server, if you do not have access to the Customer portal, or are having issues getting the information, please contact Rocket Support or your Rocket Support Provider.