Add Data Directory in connection string

waqas shah

I created an windows form application in c# during development i used following connection string and it works fine

 <add name="myconnection" connectionString="Data Source=ABC-PC\SQLEXPRESS;Initial Catalog=mydatabase;Integrated Security=True"/> connectionStrings>

but now i need to deploy application on client machine and i have to add data directory option in my connection string and i did this as

 <add name="myconnection" connectionString="Data Source=.\SQLEXPRESS; Integrated Security=True; User Instance=True;AttachDbFilename=|DataDirectory|\mydatabase.mdf;  Initial Catalog=mydatabase; "/> connectionStrings>

when i changed string then it threw and error

Unable to open the physical file "D:\Other Projects\Employee\Employee\bin\Debug\mydatabase.mdf". Operating system error 2: "2(The system cannot find the file specified.)". Cannot attach the file 'D:\Other Projects\Employee\Employee\bin\Debug\mydatabase.mdf' as database 'mydatabase'.

and calling connection string as

SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString);

I used SQL server 2008.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth11y ago
Welcome always waqas shah
0
waqas shah11y ago
Thanks for you time. I found the issue my connection string is correct i only copy my database file and paste it to project folder before this database was stored in MS SQl DATA folder.
0
Rajeesh Menoth11y ago
Hi,

GO to the folder r where you have stored mdf file. select file-> Right click ->click on . give full permissions to file for logged in user Security.

Follow this link : http://www.codeproject.com/Questions/557667/Unalbeplustoplusattachplussqlplusdatabaseplus-Micr
0
waqas shah11y ago
it threw same error as i mentioned.
0
Upendra Pratap Shahi11y ago

0
Rajeesh Menoth11y ago
Hi,

Ref the following links,

1) https://social.technet.microsoft.com/Forums/windowsserver/en-US/4e830812-4107-40c3-8c8e-1d36552119fc/unable-to-open-the-physical-file-dprogram-filesmicrosoft-sql?forum=sqldatabaseengine

2) http://dba.stackexchange.com/questions/98807/unable-to-open-sql-server-database-file-mdf/98812

3) http://community.embarcadero.com/index.php/article/articles-database/1050-pinal-dave

4) http://www.sqlandssrssolutions.com/2014/07/unable-to-open-physical-file-in-sql.html

5) http://www.exacthelp.com/2012/12/unable-to-open-physical-file-operating.html
0
waqas shah11y ago
I tried this but it gave me error that "Unable to open the physical file error 2: "2(The system cannot find the file specified.)""
0

Rajeesh Menoth11y ago

Hi,

Ref the following :

Write like this..

 <add name="myconnection" connectionString="Data Source=.\SQLEXPRESS; Integrated Security=True; User Instance=True;AttachDbFilename=|DataDirectory|mydatabase.mdf;  Initial Catalog=mydatabase; "/> connectionStrings>

1) http://stackoverflow.com/questions/19900051/how-to-manage-connection-to-aspnetdb-in-web-config