To enable the usage of SQL Native Client, ADO applications will need to implement the following keywords in their connection strings:
Provider=SQLNCLI
DataTypeCompatibility=80
For more information about the ADO connections string keywords supported in SQL Native Client, see Using Connection String Keywords with SQL Native Client.
The following is an example of establishing an ADO connection string that is fully enabled to work with SQL Native Client, including the enabling of the MARS feature:
Copy Code
Dim con As New ADODB.Connection
con.ConnectionString = "Provider=SQLNCLI;" _
& "Server=(local);" _
& "Database=AdventureWorks;" _
& "Integrated Security=SSPI;" _
& "DataTypeCompatibility=80;" _
& "MARS Connection=True;"
con.Open