Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Server Linked Server Problem
Thanks for your reply Terry, I had already tried using OpenQuery with no success. Anyway I have SOLVED my problem!!!:-) I have changed the remote query timeout option value in SQL Server from 200 (default) to 0 (0 = Infite wait) This solved the problem! I don't understand why 200 would not...- nh
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQL Server Linked Server Problem
SQL Linked Server - OLE DB Fault - connecting to Oracle Hi, I have a problem with an SQL Server Linked Server and OLE DB. WinNT (SP6) SQL Server 7 SP3 (7.00.961) MDAC Version 2.6 RTM Oracle Client 8.1.7 Oracle DB 8.0.6 (running on a Unix system) I cannot read any data using the linked server...- nh
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
