Using ADO with SQL Server Native Client

To enable the usage of SQL Server Native Client, ADO applications will need to implement the following keywords in their connection strings:

Provider=SQLNCLI10
DataTypeCompatibility=80

The following is an example of establishing an ADO connection string that is fully enabled to work with SQL Server Native Client (SQL Server 2008 R2):

Dim connection As New ADODB.Connection
connection.ConnectionString = “Provider=SQLNCLI10;” _
& “SERVER=(local);” _
& “Database=Northwind;” _
& “DataTypeCompatibility=80;” _
& “User Id=sa;” _
& “Password=Pa$$w0rd;”
connection.Open

The following is an example of establishing an ADO connection string that is fully enabled to work with SQL Server Native Client (SQL Server 2012 and SQL Server 2014):

Dim connection As New ADODB.Connection
connection.ConnectionString = “Provider=SQLNCLI11;” _
& “SERVER=(local);” _
& “Database=Northwind;” _
& “DataTypeCompatibility=80;” _
& “User Id=sa;” _
& “Password=Pa$$w0rd;”
connection.Open

SharePoint 2010 with SQL Server 2012

To install SharePoint 2010 on SQL server 2012, you will need to ensure that you have at least the SharePoint 2010 with Service Pack 1 installer. SQL Server 2012 removed the system stored procedure sp_dboptions. This is a required stored procedure for installing SharePoint 2010. Service pack 1 for SharePoint 2010 does eliminate the dependency for the sp_dboptions stored procedure.