Fra Access til MySql, men hvordan laver man.

Jeg leger lidt med tanken om at smide mine gamle Access over i MySql, jeg har konverteret databaserne om til MySql, men hvormeget skal så laves om i koden ?

Jeg troede at det var nok bare at lave en ny connection

<%
Conn_String = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("accessdatabase.mdb")
    Set Conn=Server.CreateObject("ADODB.Connection")
    Conn.Open Conn_String
    sql = "select * from cat order by cat"
    set rs = Conn.Execute (sql)
%>

Til

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={mySQL}; Server=xxx.xxx.xxx.xxx; Port=3306; Option=131072; Stmt=; uid=uidher; pwd=pwdher;"
    Conn.Open Conn_String
    sql = "select * from cat order by cat"
    set rs = Conn.Execute (sql)
%>