Central Indiana Linux Users Group
User: Guest Log in |  Join
MySQL Presentation
First page Back Continue Last page Overview Graphics

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:

Apr. 1, 2004 2:54 pm US/Eastern