4

I am trying to open an .sdf file in Visual Studio Web Express 2012. It's my local Orchard environment, but I suppose that doesn't matter much, as I have found this error all over the place when Googling. However I only found solutions for Visual Studio 2010 and lower, so they don't seem to apply to me, since they usually include installing Visual Studio 2010 Tools for SQL Server Compact. Which doesn't work with 2012 obviously.

Here is the error when I try to open the file directly from VS Solution Explorer:

Unspecified Error

What the heck?

When I try to configure a data connection the SQL Server Compact isn't there:

Configure new data connection

I tried to reinstall SQL Server Compact Latest via the Web Platform Installer, but that didn't help. I can however, open the database in LinqPad:

Orchard.sdf in LinqPad

Any ideas on whats going on with Visual Studio 2012?

Thx

PS: Sorry if I overlooked the solution somewhere. Got only 2 hours of sleep or so.

Alexander Rechsteiner
  • 5,694
  • 5
  • 34
  • 47

1 Answers1

0

Take a look at this MSDN Forum posting. It doesn't exactly match your circumstances, but I believe this particular problem is tied to source control and not the language you're working with.

The answer on what to do is about 2/3rds of the way into that posting.

So, I unbound the projects (select solution file, then File -> Source Control -> Advanced -> Change Source Control), and then rebound them.

After some additional investigation, I found that this issue may be related to the .suo file. This SO answer indicates that the .suo file is effectively disposable, so you can close your solution; delete the .suo; re-open the solution and the "Unspecified error" should go away.

I've tried both methods (unbind | bind) and deleting the .suo file, and both of them worked for me.

Community
  • 1
  • 1