Using SQL Server Native Client provider 10 (SQLNCLI10) using SQLXMLOLEDB.4.0

Connection string

This SQLXML 4.0 OLEDB Provider connection string can be used for connections to SQL Server 2008.

Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI10;Data Source=myServerAddress;
Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;