SQL Server Express Instance in ODBC Driver
In this article I am going to explain about how to use SQL server instance and express instance in ODBC Driver.
Introduction
To create connection string using SQL server instance in SQL server native client 10.0 ODBC Driver we need to put provider, path and file name of instance, your database name, set the state of Trusted connection to true.
Syntax
Driver={SQL Server Native Client 10.0};Server=.\SQLExpress;AttachDbFilename=c:\database\project\file1.mdf; Database=dbname;Trusted_Connection=Yes;
|
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