Hi, I just transferred some of my access tables to MySQL and I'm already running into some problems. Below are my connection strings and coding.

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/consoletopmainie.asp, line 39

Dim conn, source

Source = "DRIVER={MySQL ODBC 3.51 Driver};Server=;UID=vgameforcecom;PWD=maggie;database=vgameforcecom;PORT=3306;Option=16386" 
Set conn = Server.CreateObject("ADODB.Connection")
conn.open Source
line 39 is the rsuser.update

  sql = "SELECT * FROM Users WHERE username = '" & username & "'"
  Set rsUser = Server.CreateObject("ADODB.Recordset")
  rsUser.Open sql, conn, 3, 3