Thank you for the reply.
The timout is set in seconds ( 600 ) which comes out to 10 minutes.
Unfortunately, changing this to 0 for unlimited has no effect. The query
still times out after 30 seconds.
I have still to try chagning the remote query timout using sp_configure.
A. Can this setting be changed in a query? If so, I tried
sp_configure 'remote query timeout','0'
before the query statement and received only an error message.
B. If this is not changed within a query, where can the stting be
C. Is there a setting that should be changed on both the server &
Thank you -
> I believe that the timeout value is in seconds, not minutes.
> You can force the timeout for the ODBC connection object or simply change
> "remote conn timeout" and "remote query timeout" to 0 to get unlimited
> Shahar Tamari
> Toolsmith Consulting
> > When running a query on a very large database, I receive this error
> > 30-50 seconds:
> > [Microsoft][OBDC SQL Server Driver][Timeout Expired]
> > We are using NT and 98. I receive this error message running the queries
> > the client and the server. We just switched over from Access 97, which
> > unable to handle the amount of data. Using Access 97 ODBC pass-through
> > queries, we recevied a similar error message, but it was a simple fix -
> > select properties and change the timeout.
> > This doesn't happen with queries that return only a small number of
> > The queries I am receiving the error message on are attempting to return
> > million rows.
> > The default timeout setting is 10 minutes, and so far that is the only
> > setting I can find.
> > I appreciate any help on this matter!