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
  • 2243

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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.