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!
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!