I bought a new computer and installed SQL Server Express 2014 and Visual Studio Express 2013. I've been able to connect to attach the database I created in SQL Server Express 2012 in SQL Server Express 2014 and view and edit tables.
When I try to work with my web site in Visual Studio Express 2013, I've been having a variety of problems. Most recently, the error message is:
"An exception of type 'System.Data.SqlClient.SqlException' occurred in App_Web_c0sv1x2m.dll but was not handled in user code
Additional information: Unable to open the physical file "C:\Safety_Designs\App_Data\SafetyDesigns.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
An attempt to attach an auto-named database for file C:\Safety_Designs\App_Data\SafetyDesigns.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
That's the error message I get when I use the Connection String "Data Source=(LocalDB)/v11.0"
When I change the Connection string to v12.0 (this was suggested somewhere else), I get a different error:
"The database 'DB Path' cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported." along with the above error.
I don't understand what the problem is. The file is there and it's not being used by any other process that I can see. There's no other DB with the same name.
Any help is greatly appreciated. Thanks.