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