Patent ID: 8370511

Claim:
A server comprising: a processor; and a database having an interface for receiving database requests that are formatted according to a tabular data stream (TDS) protocol that comprises: a multiple active result set (MARS) header that identifies that multiple active result sets are to be generated in response to the execution of queries in a number of pending requests received over a single database connection, and a data field that is part of the MARS header that identifies the number of pending requests active over the single database connection known by a client to the server, wherein the server uses the MARS header to synchronize execution of queries from the pending active requests for communication between the client and the server, regardless of buffer size for the client and the server such that the client is enabled to send a plurality of active requests to the server using a single database connection to be executed concurrently, wherein the server, while the database connection is open, receives a reset request from the client and thereafter resets the database connection; wherein the server further receives a subsequent database request over the same database connection that has been reset; and wherein the server uses the interface to receive the database requests, including the subsequent database request over the same database connection after the database connection has been reset.