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

Code:
<%
Dim conn, source

Source = "DRIVER={MySQL ODBC 3.51 Driver};Server=192.168.14.188;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

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

    rsuser("lol")=now()
  rsUser.Update