SDAC

TMSConnectionOptions.MultipleActiveResultSets Property

Enables support for the Multiple Active Result Sets (MARS) technology.

Class

TMSConnectionOptions

Syntax

property MultipleActiveResultSets: boolean default DefValMultipleActiveResultSets;

Remarks

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.

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback