Connecting via ODBC

• <%

• MyDatabase = "driver={MySQL};server="&MySQLSVR&";port="&MySQLPRT&";uid="&MySQLUID&";

• pwd="&MySQLPWD&";database="&MySQLDB&";option="&MySQLOPT&""

• Set MyConn = Server.CreateObject("ADODB.Connection")

• MyConn.Open MyDatabase

• SQL = "INSERT INTO urlorg (name,comment,url,categ)

• VALUES ('"&name&"','"&comment&"','"&url&"','"&categ&"');"

• MyConn.Execute SQL

• MyConn.Close

• %>

Notes: