Have just upgraded to MYSQL 5.0 and can only get it working using the old
MYODBC driver and updating the user table password to OLD_PASSWORD()
when using the new ODBC connector I get the following error:

Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'con.execute'

CODE:

set con =Server.CreateObject("ADODB.Connection")
con.open "Driver={MySQL Connector/ODBC v5}; Server=localhost; Database=db; Uid=user; Pwd=password;"

set rs=con.execute("SELECT id FROM table")
if (Not rs.Eof) then
do while (Not rs.Eof)
response.write "id: " & rs("id") & "<br />"
rs.MoveNext
loop
end if
rs.close
set rs = Nothing
con.close
set con = Nothing

Any suggestions are much appreciated, thnx.

I've heard this before, but haven't run into it yet.

A good place to start would be here .

Good luck.