SourcePro DB : DB Access Module for Microsoft SQL Server User’s Guide : Technical Information : Result Sets : Simultaneous Processing of Results from Multiple Statements Using the Same Connection
Simultaneous Processing of Results from Multiple Statements Using the Same Connection
The DB Access Module for Microsoft SQL Server queries the SQL Server driver for the maximum number of simultaneously active SQL statements (SQLHSTMT) allowed per connection (SQL_MAX_CONCURRENT_ACTIVITIES). If a connection is used for a new operation, but already has the maximum number of simultaneous operations active, the results of the oldest operation are silently discarded.