How to Use SQL Server Instance in OLE DB Provider
In this article I am going to explain about how to create connection string using SQL server instance in SQL server native client 10.0 OLE DB provider.
Introduction
Here I am explaining how to create connection string using SQL server instance and express instance in SQL server native client 10.0 OLE DB provider. To create connection string using SQL server instance in SQL server native client 10.0 OLE DB provider we need to put provider, your instance name, your database name and set the state of trusted connection to yes.
Syntax
Provider=SQLNCLI10;Server=urServerName\theInstanceName;Database=urDataBase;Trusted_Connection=yes;
|
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here