Question

Locked

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.

Thanks.
Regards.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums