Connect to MySql database on web server with AdoLisp?

[Hypersonic]

Hi all, I am using a connection string like this for an Access database on a local server.
Currently using Jon Flemings ADOLisp (Thanks Jon!)

(setq ConnectString (strcat "Driver={Microsoft Access Driver (*.mdb)};Dbq=" mdb_file ";Uid=" UserName ";Pwd=" Password ";"))

(setq ConnectionObject (ADOLISP_ConnectToDB ConnectString UserName Password))

Can anyone provide an example of connecting to a MySql database on a web server?

Thanks!

[Hypersonic]

I am trying the following connect strings, but they fail,  I am passing correct user name and password.  When either of these are run, a long pause occures idicating something is trying to work, then it just returns nil.....

Anyone have any experience with trying this with a web server MySql database?

(setq ConnectString (strcat "DRIVER={MySQL ODBC 3.51 Driver};" "SERVER=stampingsolutionsgroup.com;"  "DATABASE=wihon_rcmtool;"  "USER=" UserName ";PASSWORD=" Password ";"))
;stalls (setq ConnectString (strcat "DRIVER={MySQL ODBC 3.51 Driver};" "Server=stampingsolutionsgroup.com;" "Port=3306;" "Option=16384;" "Database=wihon_rcmtool;" "Uid=" UserName ";Pwd=" Password ";"))


(setq ConnectString (strcat "DRIVER={MySQL ODBC 3.51 Driver};" "SERVER=stampingsolutionsgroup.com;"  "DATABASE=wihon_rcmtool;"  "USER=" UserName ";PASSWORD=" Password ";"))
;stalls (setq ConnectString (strcat "DRIVER={MySQL ODBC 3.51 Driver};" "Server=stampingsolutionsgroup.com;" "Port=3306;" "Option=16384;" "Database=wihon_rcmtool;" "Uid=" UserName ";Pwd=" Password ";"))



Thanks!