It must be in how you are putting the DataSource string together - if you
can enter it in the mySQL client and it works...I think it almost has to be
something in the DataSource string.
-seanA
> Message: 15
> Subject: mysql connection failure
> From: "rb at juun dot com" <rb at juun dot com>
> Date: Tue, 31 Aug 2004 23:56:44 +0000
>
>
> ok, i downloaded and "installed" the db plugins from the rb website, closed=
> and relaunched the rb ide, created a brand new project, and put the follow=
> ing code in the action method of a pushbutton:
>
> dim db as MySQLDatabase
> db =3D new MySQLDatabase
> db.host =3D "localhost"
> db.username =3D "mrpib"
> db.password =3D "mrpibpass"
> db.databasename =3D "dude"
> if db.connect then
> msgbox "good"
> else
> msgbox "bad"
> end if
>
> it fails every time. compiles and runs, but db.connect() is returning fals=
> e.
>
> the mrpib user has been granted full access to the "dude" db.
>
> using the command-line mysql client, i can connect to the "dude" db as user=
> "mrpib" with pass "mrpibpass" (from localhost) and modify/read it to my he=
> art's content.
>
> why is it that this rb code is failing?
>
> os x 10.3.4 / rb 5.5.3 / mysql 4.1.3
>
> thanks.
>
> - philip
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>
|