SQLXMLOLEDB.3.0Using SQL Server Ole Db

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;

Connecting

This connection string (Using SQL Server Ole Db using SQLXMLOLEDB.3.0) can be used for connections to SQL Server 2000 and SQL Server 7.0.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.