Visual Studio Server Explorer Add Data Connection (Attach mdf file from App_Data)

Question

0.00/5 (No votes)

See more:

Hello guys
I am developing a shopping cart in AP.NET. 2 days ago i created a database in "SQL SERVER 2008 R2". It was created successfully and everything went fine. I then copied that Database named "ESTORE" to the App_Data of my Project. But now i want to add this in "Server Explorer => Data Connections => Add Data Connection". and everytime it gives me an error like an attempt to attach an auto-named database for file C:\Users\cYpH3R x3r0\My Documents\Visual Studio 2010\Websites\New\App_Data\ESTORE.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Link is given here, that describes my problem best.
http://i1066.photobucket.com/albums/u401/sherry1232/errorpng.png

Sorry if that questions sounds ugly, i am new to ASP.NET and SQL Server (Recently Switched from PHP)

Posted 14-Feb-12 22:25pm

cYpH3r x3r0

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

cYpH3r x3r0 · Accepted Answer · 2012-02-23T03:45:00

Solution 1

used data connection instead, coz App_Data folder has higher security and is more difficult to access

Posted 23-Feb-12 3:45am

cYpH3r x3r0