I was using an ACCESS DB but then I discovered the wonderful world of mySQL. I've been going through my site and changing the pages over. So far, all I've had to do was change the DSN. But, I've finally hit an error.

Is there a site that explains the differences between Access and mySQL? sql syntax, supported methods, etc?

The error is: 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. /admin/modifyuser.asp, line 62

I'm using mySQL 3.23.37 on Windows NT Server 4.0 via ASP via myODBC 2.50.37

This code: Set oConnect = Server.Createobject("ADODB.Connection") oConnect.Open "DSN=mysqldb" Set rsPost = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM users WHERE id=" & Request("id") rsPost.Open strSQL, oConnect, adOpenStatic, adLockOptimistic rsPost("uname") = Request("uname") rsPost("pass") = Request("pass") rsPost("cnty") = Request("cnty") rsPost("first") = Request("first") rsPost("last") = Request("last") rsPost("title") = Request("title") rsPost("phone1") = Request("phone1") rsPost("phone2") = Request("phone2") rsPost("up") = 0 rsPost("ad") = 0 If Request("up") = "yes" then rsPost("up") = 1 If Request("ad") = "yes" then rsPost("ad") = 1 rsPost("email") = Request("email") rsPost.Update