I'm using Visual Studio 2008, and my database is SQL
I want to add a connection to the Server Explorer in VS. The Data
source is Microsoft SQL Server (SqlClient). After entering in all my
information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open
and available connection. The connection's current state is closed.What's going on here?
View Complete Post