Can't connect to MySQL server using revOpenDatabase

[jbv]

Hershel,

I actually tried every possible combination,
but nothing works... I still get that error 61
(or 10061 on Windows)...

My problem is that I can't decide if it's a
configuration problem on my server, or a Rev
problem... Here's why : I was also trying to get
a connection to MySQL with Rev-cgi linux (on the
same server). And the right spelling (according to
Rev documentation) for a DB that is listening on
port 5432 is : localhost:5432 (instead of
www.example.com:5432). But that doesn't work
(same error).
I finally managed to get that connection to MySQL with
Rev-cgi by using : localhost (and dropping :5432).

It works, but I really don't understand why...

JB

> What happens when you spell it out ?
> on handler
>    put
> revOpenDatabase("MySQL","www.example.com:5432","myDB","myUSR","myPWD",(m
> ake sure the last comma)) into tR
>    answer tR
> end handler
> Hershel Fisch
>
> On Monday, October 18, 2004, at 07:05 AM, jbv wrote:
>
> > Hi list,
> >
> > Still fighting with databases connections...
> >
> > I'm trying to open a connection to MySQL using
> > revOpenDatabase in the IDE and I get this error :
> >
> > Can't connect to MySQL server on 'www.example.com:5432' (61)
> >
> > ALTHOUGH IT WORKS WITH the DB Query
> > Builder (connection status : connected) !!!!
> >
> > MySQL is configured on port 5432, which is open in
> > the firewall.
> > Here's the script I'm using :
> >
> > on mouseUp
> >   put "root" into myUSR
> >   put "******" into myPWD
> >   revSetDatabaseDriverPath "/Macintosh HD/Desktop Folder/Revolution
> > 2.5/components/global
> > environment/database_drivers/MacOSX/dbmysql/Contents/MacOS/dbmysql"
> >   get
> > revOpenDatabase("MySQL","www.example.com:5432","myDB",myUSR,myPWD)
> >
> >   put it
> > end mouseUp
> >
> > In the archives, I found a msg from someone saying
> > that "root" isn't accepted by MySQL as user on a
> > distant machine, but in that case why does it work
> > in the DB Quary Builder ?
> >
> > What am I missing or doing wrong ?
> >
> > Thanks,
> > JB
> >
> >
> > _______________________________________________
> > use-revolution mailing list
> > use-revolution at lists.runrev.com
> > http://lists.runrev.com/mailman/listinfo/use-revolution
> >
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution