I have setup a linked server using ODBC to connect to an Oracle database, I can execute inserts, updates and deletes without problem but when I query the database it only gives me the first row of the table, eg:
SET ROWCOUNT 0
SELECT * FROM OPENQUERY(PerformOEE_OLink,'SELECT * FROM ud_downtime ORDER BY tester')
This returns one row.
I have setup the linked server previously using OLE DB for Oracle and everything worked fine, but this may not be available on another server which I need to configure.
Any help is appreciated.