Using SQL Server Ole Db using SQLXMLOLEDB.3.0

Connection string

This SQLXML 3.0 OLEDB Provider connection string can be used for connections to SQL Server 2000 and SQL Server 7.0.

The SQLXML version 3.0 restricts the data provider to SQLOLEDB only.

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