mIRC Home    About    Download    Register    News    Help

Print Thread
ADODB.connection Fail #160920 01/10/06 01:48 PM
Joined: Feb 2006
Posts: 4
P
poste9 Offline OP
Self-satisified door
OP Offline
Self-satisified door
P
Joined: Feb 2006
Posts: 4
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!
frown

Last edited by poste9; 01/10/06 01:59 PM.
Re: ADODB.connection Fail #160921 01/10/06 09:05 PM
Joined: Apr 2004
Posts: 759
M
Mpdreamz Offline
Hoopy frood
Offline
Hoopy frood
M
Joined: Apr 2004
Posts: 759
Seems to me you Open statement is off:
http://forums.mirc.com/s...true#Post115590


$maybe
Re: ADODB.connection Fail #160922 04/10/06 12:32 PM
Joined: Feb 2006
Posts: 4
P
poste9 Offline OP
Self-satisified door
OP Offline
Self-satisified door
P
Joined: Feb 2006
Posts: 4
that solution dont worked =\

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

Re: ADODB.connection Fail #160923 04/10/06 02:03 PM
Joined: Apr 2004
Posts: 759
M
Mpdreamz Offline
Hoopy frood
Offline
Hoopy frood
M
Joined: Apr 2004
Posts: 759
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.


$maybe