SQL Server Message 7370

[mark06]

&quot;One or more properties could not be set on the query for OLE DB provider 'MSDASQL'. The provider could not support a required property.&quot;<br>
<br>
Connecting to a linked server (Oracle) from a network install of SQL Server and performing any SQL query gives the above message. When I configure a linked server on a local SQL Server engine, everything works fine.<br>
<br>
SQL Server books online pointed me to a microsoft FAQ page, which in turn pointed me back to books online. Not amusing!<br>
<br>
Anybody help me!<br>
<br>
Ta.

 

[mark06]

I got off my lazy backside and sorted this out myself.<br>
<br>
a) I used sp_configure to compare the run_value of both databases and found that 'remote query timeout (s)' was different - it ought to have been zero on the server but was in fact 10.<br>
<br>
b) Solution :<br>
<br>
sp_configure 'remote query timeout (s)', 0<br>
go<br>
reconfigure<br>
go<br>
<br>
Mark.