Data Directory SQL Server Express Instance in ODBC Driver
In this article I am going to explain about how to use data directory SQL server express instance in ODBC Driver.
Introduction
Here I am explaining how to use data directory SQL server express instance in SQL server native client 10.0 ODBC Driver.
To create connection string using the data directory SQL server express instance in SQL server native client 10.0 OLE ODBC Driver we need to put provider, file name , your database name, set the state of Trusted connection to true.
Syntax
Driver={SQL Server Native Client10.0};Server=.\SQLExpress;AttachDbFilename=|DataDirectory|urdbfile.mdf;Database=dbname;Trusted_Connection=Yes;
|
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here