Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    14

    Unanswered: MYODBC Issues after upgrading to MTSQL5.0

    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.
    Last edited by lazyTrucker; 12-16-05 at 10:54.

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    I've heard this before, but haven't run into it yet.

    A good place to start would be here .

    Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •