This messages indicates that the query took more time to process than the time that is specified in the remote query timeout configuration setting.īy default, in Microsoft SQL Server 7.0, the timeout setting is zero (0 - infinite wait). The second error message pertains to the ICommandText::Execute method. When the query attempts to establish a connection to the remote server, the first error message occurs if the time it takes the query to establish a connection exceeds the remote login timeout option value.
The first error message pertains to the IDBInitialize:Initialize method.
Microsoft SQL Server 2000 Distributed Queries: OLE DB Connectivity You may also refer to the following topics in MSDN for a description of how the query processor interacts with an OLE DB provider to enable distributed and heterogeneous queries: Set the remote query timeout to 0 (infinite wait), by using this code:įor more information about the remote login timeout setting and where IDBInitialize::Initialize is called, refer to the "Connecting to an OLE DB Provider" topic in MSDN or the Microsoft SQL Server 7.0 Resource Guide in the BackOffice Resource Kit. Set the remote login timeout to 30 seconds, by using this code: sp_configure 'remote login timeout', 30 To work around this, you can reconfigure the timeout setting.īased on which type of error you encounter, you can reconfigure the timeout setting as follows: Refer to the "More Information" section of this article for further details about the timeout options. The error messages occur when a query exceeds the timeout option values.
There are two configurable timeout options that affect the execution of remote queries. Execution terminated by the provider because a resource limit was reached. Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB' reported an error.
0 kommentar(er)
