E
Elmo Watson
I have a class - I Dim a SQLconnection, then, in Sub New, I instantiate it,
so that it's available to me whenever I reference the class (correct?):
Conn = New SqlConnection(msConn)
Then, in my Subs/Functions, this section (inherited from previous author):
If Conn.State = ConnectionState.Closed Then
Conn.ConnectionString = msConn
Conn.Open()
End If
I step through this, line by line, and Conn.Open never actually opens the
connection. I do a quick watch on 'Conn' and pretty much everything looks
right. the connection is there, the connectionstring is correct.
However - I did a quick watch on 'Conn' - - all except one thing looked
good - on the server version, it reported an error:
ServerVersion <error: an exception of type:
{System.InvalidOperationException} occurred> String
MSDN didn't help -
Any ideas on this?
so that it's available to me whenever I reference the class (correct?):
Conn = New SqlConnection(msConn)
Then, in my Subs/Functions, this section (inherited from previous author):
If Conn.State = ConnectionState.Closed Then
Conn.ConnectionString = msConn
Conn.Open()
End If
I step through this, line by line, and Conn.Open never actually opens the
connection. I do a quick watch on 'Conn' and pretty much everything looks
right. the connection is there, the connectionstring is correct.
However - I did a quick watch on 'Conn' - - all except one thing looked
good - on the server version, it reported an error:
ServerVersion <error: an exception of type:
{System.InvalidOperationException} occurred> String
MSDN didn't help -
Any ideas on this?