tags:

views:

208

answers:

2
Q: 

During Open(), SqlConnection.ServerVersion throws System.InvalidOperationException

When running a webservice, web page that knows how to respond. The service connects to a dbase. During the sqlconnection.open call, ASP .NET code throws the following exception:

sqlConnection.ServerVersion' threw an exception of type 'System.InvalidOperationException'

NOTE: I'm running this on my dev machine. When it runs on live web server, all is well. It is unique to my system.

I'm I missing a configuration setting with Sql Server 2008?

NOTE: recently upgraded from Sql Server 2005 to 2008

A: 

This could possibly be caused by a difference in your web.config between the live server and your dev machine. Have you checked that the connection string is properly specified?

Tim Goodman  2010-01-20 23:25:02
The connection string is same for both environments, same copy of web.config
Larry  2010-01-21 16:09:14
I'm glad you found your problem with the connection string. If my reply was helpful, please consider marking it as the answer. (I'm trying to get to however many reputation points I need to post comments on other people's answers.)
Tim Goodman  2010-01-21 18:24:01
A: 

Found problem. There was a space in the front of the connection string.

Larry  2010-01-21 17:37:34

related questions

SqlConnection - is remote or local connection?
Login Problem Windows Authentication
Windows Authentication Trusted Connection Problem?
When should I open and close a connection to SQL Server
What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout?
ExecuteReader requires an open and available Connection. The connection's current state is closed.
Not allowed to change the 'ConnectionString' property. The connection's current state is open.
Windows Mobile - auto connect to Internet (GPRS) when opening SqlConnection (.NET)
How to get ASPNET to be recognized as a Trusted Connection by SQL Server 2005
Diagnosing SqlConnection leaks?
How to force SQLconnection to release a database???
Identifying underlying sql connection of SqlConnection object
SQLConnection Pooling - Handling InvalidOperationExceptions
How to use ADO.net Entity Framework with an existing SqlConnection?
Best way to handle sql-connections in webservice?
How to find unclosed connection? Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
.net SqlConnection not being closed even when within a using { }
Why call SqlClient.SqlDataReader Close() method anyway?
Does .net SqlCommand.ExecuteReader close connection?
Does .Net do clever connection management like PHP?
How to test SqlServer connection without opening a database
What is the proper way to ensure a SQL connection is closed when an exception is thrown?
How can I tell how many SQL Connections I have open in a windows service?
Breakpoints in core .NET runtime?
Is SqlCommand.Dispose enough?