SQL Server Native Client in SQL XML 4.0 OLEDB

In this article I am going to explain about how to use SQL server native client in SQL XML 4.0 OLEDB.
  • 2078

Introduction

Here I am explaining how to create connection string which bridging to SQL native client in SQL XML 4.0 for OLE DB.

To create connection string which use SQL native client in SQL XML 4.0 for OLE DB we need to put your provider, your server address, your database name, your user name and your password.

Syntax

 Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI10;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.