Forums Scripts & Popups ADODB.connection Fail

Can someone help me pls?



alias SQLL {
if ($com(SQL)) { .comclose $ifmatch }

.comopen SQL ADODB.Connection

var %sql = $com(SQL,Provider,4,bstr,MySQLProv)

var %sql = $com(SQL,ConnectionString,4,bstr,DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=db;USER=root;PASSWORD=;OPTION=3)

var %sql = $com(SQL,Open,1)
echo $iif($com(SQL).error,$com(SQL).errortext ( $+ $ifmatch $+ ),Great!)

.comclose SQL
}

Never returned Great!

Seems to me you Open statement is off:
https://forums.mirc.com/s...true#Post115590

that solution dont worked =\

the connection cant open in my pc.. i dont know why, but dont open.

You positive you have got the MySQL ODBC 3.51 Driver ?
its downloadable from the mysql site, install it and see if it makes a difference.