Wednesday, March 7, 2012

How to set Multiple Active results Sets (MARS) enable in ODBC

hello all there

can any body tell me how could i set the Multiple Active results Sets (MARS) option on/yes in case of the ODBC.

The thing is i create the connection using the SQL Native(sql sqrver-2005)wizard,

i got following when create the DNS

Microsoft SQL Native Client Version 09.00.1399

Data Source Name: DM_N
Data Source Description:
Server: vsnet1
Use Integrated Security: No
Database: DM
Language: (Default)
Data Encryption: No
Trust Server Certificate: No
Multiple Active Result Sets(MARS): No
Mirror Server:
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes

i just want to set the

Multiple Active Result Sets(MARS): YES

how could i ?

any help, solution or hint

Regards

Thanks

GSG

use this within your SQL Server connectionstring:

"Driver={SQL Native Client};Server=Aron1;Database=pubs;Trusted_Connection=yes;MARS_Connection=yes"

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment