How to Enabling MARS in OLE DB Provider
In this article I am going to explain about how to create connection string with enabling MARS in OLE DB provider. MARS stands for Multiple Active Result Sets.
Introduction
Here I am explaining how to create connection string with prompt for enabling MARS (Multiple Active Result Sets) OLE DB provider.
Enabling MARS
To create connection string enabling MARS (Multiple Active Result Sets) in SQL server native client 10.0 OLE DB provider we need to put provider, your server address, your database name, set the state of Trusted connection and MARS connection to true.
Syntax:
|
Provider=SQLNCLI10;Server=urServerAddress;Database=urDataBase; Trusted_Connection=yes;MARS Connection=True;
|
Further Readings
You may also want to read these related articles :
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here