You cannot access a SQL Server database by using the OLE DB provider for SQL Server when your application is in a high-stress scenario
Retired KB Content Disclaimer
For example, the following behavior may occur:
- A new SQL query uses a firehose cursor.
Note A firehose cursor is a server-side, forward-only, and read-only cursor.
- The new SQL query is executed on an OLE DB session or on an ADO connection that uses SQLOLEDB.
- The OLE DB session or the ADO connection is already busy processing result sets from a previously existing query.
When a large enterprise application is in a high-stress scenario, running many of these new SQL queries creates many corresponding non-pooled implicit connections. Therefore, you may receive "General Network Error" error messages.
You may receive these error messages because one or more of the following conditions are true:
- The SQL Server WinsockListenBacklog registry setting sets the maximum number of simultaneous new login requests. However, the number of simultaneous new login requests from the new non-pooled implicit connection to the computer that is running SQL Server exceeds this value.
- The MaxUserPort registry setting limits the number of ephemeral TCP/IP ports on the application computer. However, the application requires more ephemeral TCP/IP ports to be assigned by Windows Sockets for the new non-pooled implicit connections.
- The TCPTimedWaitDelay registry setting prevents TCP/IP socket ephemeral ports on the application computer from recycling fast enough to meet the demand for new implicit TCP/IP connections for the new non-pooled implicit connections.
- Avoid implicit connections in large enterprise application scenarios. Instead, explicitly create additional OLE DB data source/session pairs, or explicitly create ADO connections.
- Avoid using the firehose cursor on a SQLOLEDB session or an ADO connection that will process multiple result sets at the same time.
- Set the multiple connections property of the ADO connection to false, or set the OLE DB DBPROP_MULTIPLECONNECTIONS property to VARIANT_FALSE.
- Use the SQL Server 2005 Native Client API. SQL Server 2005 Native Client supports Multiple Active Result Sets (MARS). MARS maintains multiple result sets over the same OLE DB session or ADO connection.
For more information about SQL Server 2005 Native Client and MARS, visit the following Microsoft Developer Network (MSDN) Web sites:Microsoft SQL Server Native Client
Using Multiple Active Result Sets (MARS)
Using ADO with SQL Native Client
Article ID: 907264 - Last Review: 03/14/2007 06:51:05 - Revision: 1.2
- kbdesign kbnofix kbtshoot kbprb KB907264