|
TMSConnectionOptions.MultipleActiveResultSets Property |
|
|
|
TMSConnectionOptions.MultipleActiveResultSets Property |
|
Enables support for the Multiple Active Result Sets (MARS) technology.
property MultipleActiveResultSets: boolean default DefValMultipleActiveResultSets;
Use the MultipleActiveResultSets property to enable support for the Multiple Active Result Sets (MARS) technology. It allows applications to have more than one pending request per connection, and, in particular, to have more than one active default result set per connection. Current session is not blocked when using FetchAll = False, and it is not necessary for OLE DB to create additional sessions for any query executing. MARS was supported in SQL Server versions since SQL Server 2005 with using SQL Native Client as OLE DB provider.