How to create SQLXML Connection String in .NET Framework for OLEDB Provider
In this article, I will explain How to create SQLXML OLEDB Provider in .NET Framework
QLXML OLEDB Provider in .NET Framework
Introduction
-
SQLXMLOLEDB Provider is an OLE DB provider.
-
SQLXMLOLEDB Provider exposes Microsoft SQLXML functionality through ActiveX Data Objects (ADO).
-
SQLXML OLEDB Provider provided by Microsoft.
-
SQLXML OLEDB is contained in the Sqlxml3.dll.
-
SQLXML OLEDB restricted the data provider to SQLOLEDB only.
To create SQLXMLOLEDB connection string in .NET framework. we need to put provider, your server address, your database, Initial catalog, your user name and password.
Syntax
Provider=SQLXMLOLEDB.3.0;Data Provider=SQLOLEDB;Data Source=UrServerAddress;Initial Catalog=UrDataBase;User Id=UrUsername;Password=UrPassword;
|
Further Readings
You may also want to read these related articles :
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here