This OLE DB Provider is provided by Microsoft.The provider is contained in the file sqlncli11.dll. Include "Provider=SQLNCLI11" in the connection string to use this provider.
We have SQL Server Native Client 11.0 OLE DB Provider installed on our servers, you can use it directly, please see the sample connection string below
Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;
If you got error like
System.InvalidOperationException: The 'SQLNCLI10' provider is not registered on the local machine....
That is because, we have SQL Server Native Client 11.0 OLE DB installed not SQL Server Native Client 10.0 OLE DB, just chagne
Provider=SQLNCLI1
0 to
Provider=SQLNCLI1
1 in your connection string would be ok.
Article ID: 322, Created: January 22, 2013 at 2:48 AM, Modified: January 22, 2013 at 2:49 AM