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;