c# Database error

Question

SqlConnection con = new SqlConnection(@"Server=.\SQLEXPRESS;AttachDbFilename='C:\HashTags.mdf';Integrated Security=True;User Instance=True");

con.Open();
String queryStr = "SELECT name FROM ttable WHERE name LIKE '*%'";
SqlCommand com = new SqlCommand(queryStr, con);
SqlDataReader sdr = com.ExecuteReader();

while (sdr.Read())
{
    this.trendingBx.Text = sdr.GetValue(0).ToString();
}

sdr.Close();

Could anyone tell me why I get this error:

A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

marc_s · Accepted Answer · 2012-04-19 20:31:07Z

1

Are you sure the database is not already attached? If it is you should use:

Data Source=.\SQLEXPRESS;Database=your database name;Integrated Security=SSPI

edited Apr 19, 2012 at 20:31

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 19, 2012 at 19:51

richk

4162 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

richk Over a year ago

SqlConnection con = new SqlConnection(@"Server=.\SQLEXPRESS;Database=HashTags;Integrated Security=sspi");

marc_s · Accepted Answer · 2012-04-19 20:30:48Z

0

You should use:

Integrated Security=SSPI

not

Integrated Security=True

in your connection string.

edited Apr 19, 2012 at 20:30

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 19, 2012 at 19:47

Har

5,0942 gold badges22 silver badges22 bronze badges

Comments

marc_s · Accepted Answer · 2012-04-19 20:31:01Z

0

Assuming that the "specified file cannot be opened, or it is located on UNC share" you have already checked & the .mdf does exist at the location, I think you need not have the quotes in the connection string:

AttachDbFilename='C:\HashTags.mdf'

should be:

AttachDbFilename=C:\HashTags.mdf (no single quotes)

and this should work IMO.

edited Apr 19, 2012 at 20:31

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 19, 2012 at 19:47

Sunny

6,3462 gold badges27 silver badges27 bronze badges

Collectives™ on Stack Overflow

c# Database error

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related