Connect to a MySQL db

[cdkid]

somethin i thought i'd share

$ObjConn = ObjCreate("ADO.Connection")
$objconn.open("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=mydb;UID=username;PWD=password;")

then to execute queries and such use

$objconn.execute("Select * from users")

...im workin on a UDF library right now. Just thought someone might find this useful

******EDIT******

forgot...

$objconn.close

******/EDIT******

Edited January 26, 2006 by cdkid

[JSThePatriot]

somethin i thought i'd share

$ObjConn = ObjCreate("ADO.Connection")
$objconn.open("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=mydb;UID=username;PWD=password;")

then to execute queries and such use

$objconn.execute("Select * from users")

...im workin on a UDF library right now. Just thought someone might find this useful

Excellent... I am wanting at somepoint as a project of mine to make a MySQL plug-in for AutoIt. Then also a GUI to read/write/access the database for you, just for the ease of use.

JS