asp链接MYSQL

安装：mysql-installer-web-community-5.6.19.0.msi

安装：mysql-connector-odbc-5.3.2-win32.msi

 

dim conn
'----------------------------------------------
sub getconn
    Set Conn = Server.CreateObject("ADODB.Connection")
'    conn.Open "dsn=mysql;driver={mysql odbc 5.3 unicode driver};uid=root;password=root"
    conn.Open  "driver={MySQL ODBC 5.3 Unicode Driver};server=127.0.0.1;database=dbox;uid=root;password=123456"
'    conn.Open  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.Mappath("/##DDNS.asp")

end sub
'-----------------------------------------------------
sub close
    conn.close
    set conn=nothing
end sub