SQL exception error message when entering / retrieving from DB

Question

When I attempt to either save data entered from a text box to my DB, or search through data in my DB I am presented with an error message of:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: An attempt to attach an auto-named database for file C: \Users\User\Documents\Visual Studio 2015\Projects\Aaron's WPF Project\Database1.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

I deleted my database, re created it, and re entered the connection string but I'm still presented with this error? Why's this.

Here is my connection string:

 SqlConnection Connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C: \Users\User\Documents\Visual Studio 2015\Projects\Aaron's WPF Project\Database1.mdf;Integrated Security=True");

There is a space after "C:". Is that also in your code, or a copy mistake? — Ethilium, Feb 27 '17 at 17:23
Check if [this answer](http://stackoverflow.com/a/9515685/1592756) has the information you need — Josh Part, Mar 01 '17 at 22:38

Dylan Nicholson · Answer 1 · 2017-03-05T21:25:00.860

0

I just spent a frustrating hour trying to figure this out. Turns out it's a normal exception thrown inside the .NET SqlClient library, and I could just ignore it and it would continue on and work just fine after that.

edited Mar 05 '17 at 21:25

answered Mar 01 '17 at 22:31

Dylan Nicholson

1,301
9
23

"normal exception" is an oxymoron. No exception should ever be considered "normal". – Josh Part Mar 01 '17 at 22:35

SQL exception error message when entering / retrieving from DB

1 Answers1