An attempt to attach an auto-named database for file abc failed

Question

1.00/5 (1 vote)

See more:

I get the error "An attempt to attach an auto-named database for file abc failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share"

private void btnsubmit_Click(object sender, EventArgs e)
        {
           
            String connectionString = "Data Source=USER\\SQLEXPRESS;Integrated Security=true; AttachDbFilename=abc;User Instance=true;";
            SqlConnection thisConnection = new SqlConnection(connectionString);
         
            

            thisConnection.Open();

            String thisQuery = "INSERT INTO abc (ID, Name, ContactNo, Email, Address) VALUES ('" + txtid.Text + "', '" + txtname.Text + "', '" + txtcontact.Text + "', '" + txtemail.Text + "', '" + txtaddress.Text + "')";
            SqlCommand thisCommand = new SqlCommand(thisQuery, thisConnection);
            SqlCommand cmd = new SqlCommand();

            thisCommand.ExecuteNonQuery();
            thisConnection.Close();

        }

Posted 2-Feb-12 1:19am

priyanka999

Updated 2-Feb-12 1:47am

Chris Maunder772.9K

v4

Add a Solution

Comments

Sridhar Patnayak 2-Feb-12 7:22am

Repost, any way what is your error?

priyanka999 2-Feb-12 7:26am

am usin windows authentication above sql connection is wrong i think

priyanka999 2-Feb-12 7:28am

An attempt to attach an auto-named database for file abc failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

3 solutions

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)

Syed Salman Raza Zaidi · Answer 1 · 2012-02-02T01:25:00

You haven't specified any error but i think you are getting error because of query

your ID column in DB is of integer type and you are sending it like string
Change it like this ==>

C#

String thisQuery = "INSERT INTO abc (ID, Name, ContactNo, Email, Address) VALUES (" + txtid.Text + ", '" + txtname.Text + "', '" + txtcontact.Text + "', '" + txtemail.Text + "', '" + txtaddress.Text + "')";

Or if your ID column is identity(ie autoincrement field) then no need to send it in query

C#

String thisQuery = "INSERT INTO abc ( Name, ContactNo, Email, Address) VALUES ('" + txtname.Text + "', '" + txtcontact.Text + "', '" + txtemail.Text + "', '" + txtaddress.Text + "')";

This is not a good practice to send parameters to query like this way as there'll be a greater chance of sql injection so yo should always use SQL Parameters to send to query

janareddyjanareddy · Answer 2 · 2012-02-02T01:26:00

Solution 2

i think problem in your data base connection in code no error can you send the error message to me

Posted 2-Feb-12 1:26am

janareddyjanareddy

Comments

priyanka999 2-Feb-12 7:31am

An attempt to attach an auto-named database for file abc failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Syed Salman Raza Zaidi · Answer 3 · 2012-02-02T01:38:00

Solution 3

keep the database file in deployment folder. and In you connection string just add the 'database=abc'. This prevents SQL server to create the auto-named database

Posted 2-Feb-12 1:38am

Syed Salman Raza Zaidi

Comments

priyanka999 2-Feb-12 7:45am

deployment folder means

Syed Salman Raza Zaidi 2-Feb-12 7:45am

where your exe file exists

An attempt to attach an auto-named database for file abc failed

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us