Monday, 26 April 2010

Annoying ADO.NET Error - Unspecified.

After doing some form code and layout etc ... I decide to alter a dataset using Visual Studio 2008's Dataset Designer ... but every attempt to connect to the source database results in 'Unspecified Error' (possibly a jet specific error - I can't reproduce this at will - it just happens to you when you are half way through doing something important for a client) ... I cannot edit the TableAdapter SQL, add a table to the designer, or even connect to a database in Server Explorer, let alone create a new connection.

The only workaround, which I have discovered through trial and error, is to close Visual Studio, re-open... then connect to the database BEFORE opening the current solution.  If the connection is opened before the solution then it has no problem.

This wasn't addressed in Visual Studio 2008 SP1 or updates since (afaik)...  resetting the VS environment doesn't help either.

No comments:

Post a comment