Problem in attaching database

Question

1.00/5 (1 vote)

See more:

Hi
I attached a database using connection string
"

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Data\ABC.mdf;User Instance=true;Initial Catalog=ABC<code><small></small></code>;Connect Timeout=30;

"
this works well
I changed my project location ,Its not working with the new location.
Can not attach Database already exist exception is comming
please help me to solve the problem

What I have tried:

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Data\ABC.mdf;User Instance=true;Initial Catalog=ABC;Connect Timeout=30;

Posted 28-Jan-18 17:39pm

Member 10296413

Updated 28-Jan-18 21:07pm

Add a Solution

Comments

VR Karthikeyan 29-Jan-18 0:38am

delete the existing connection and retry.

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)

OriginalGriff · Answer 1 · 2018-01-28T21:07:00

Solution 1

Do not attach databases, except in dev - it's a special mode for dev only that does not exist in the full version of SQL (for very good reasons). You should ensure that production DB's are managed and controlled by SQL, which means it will store it where it wants.

You can also use this: Simple SQL Connection String Creation[^] to generate a connection string for you.

Posted 28-Jan-18 21:07pm

OriginalGriff

Comments

Member 10296413 29-Jan-18 22:10pm

Im using Wpf ihave to create exe

OriginalGriff 30-Jan-18 5:47am

What does that have to do with anything? In order to run any app under Windows you need to generate an EXE file...