Error Connecting to MySQL with ASP.Net

arovner · April 27th, 2005, 01:49 PM

I have a MySQL database which I am trying to use with ASP.Net.

I have a page which is supposed to send out emails to subscribers.
It is supposed to query the DB to get the information to email,
write that the email was sent to a log, and then update the DB so
that it does not send out the email again.

The first 2 steps happen, but the last step does not. when i run the
page, i get an error that says "System.InvalidOperationException:
Connection must be valid and open".

I am using the same connection information to connect to the DB each
time, so I am not sure why I am getting that error message.

The code for the function which updates the DB is:

Code:

Function update(ByVal em As String) As Boolean

        Dim strSQL As String = 
        "UPDATE TABLE SET COLUMN1 = 'True' WHERE COLUMN2 = " + em

        Dim conn As MySql.data.MysqlClient.MySqlConnection
        Dim da As MySql.data.MysqlClient.MySqlDataAdapter
        Dim cb As MySql.data.MysqlClient.MySqlCommandBuilder
        Dim connStr As String


        connStr = "server=SERVERNAME;user id=USERNAME;
         password=PASSWORD; database=DBNAME; pooling=false"
        conn = New MySql.data.MysqlClient.MySqlConnection(connStr)
        conn.Open()

        Dim myCommand As MySql.data.MysqlClient.MySqlCommand = New 
         MySql.data.MysqlClient.MySqlCommand(strSQL, conn)
        myCommand.CommandType = Data.CommandType.Text
        myCommand.ExecuteNonQuery()   'Execute the UPDATE query

        conn.Close()   'Close the connection
        Return True
    End Function

I have the statement conn.open() to open the connection,
I am not sure what would make it invalid, any help would be great.

Thanks,
arovner