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

Connection string

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

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