SourcePro DB : DB Access Module for ODBC 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 ODBC queries the underlying database ODBC driver for the maximum number of simultaneously active SQL statements (SQLHSTMT) allowed per connection by the driver (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.