SQL Server LINKED SERVERS - Oracle Data Source

By minstrelsct ·
Hi there

My problem is that when using an Oracle datasource(defined on Windows NT using the 'Oracle in OraHome92' ODBC driver) in a SQL Server LINKED SERVER, the following query works BUT it only returns 1 row in the results set even though more (39 rows) is expected.

select *
from openquery(OracleLINKEDSVR,'select * from UFT.UFT_FILE_TYPE')

I have tried setting the ROWCOUNT to 0 but it has no effect when linking to Oracle from SQL Server in this way.

I have been told that I might need to upgrade the 'Oracle in OraHome92' ODBC driver which is dated 2003-10-24.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums