Can't connect to MySQL server using revOpenDatabase

[James Cass]

JB -

I would suggest trying Sarah's MySQL Rev code.  It really helped me get 
a jump start on connecting Rev to MySQL (running on MacOSX Panther).  
Here's Sarah's MySQL stacks:
http://www.troz.net/Rev/RevProjects/MySQL.rev.gz
http://www.troz.net/Rev/RevProjects/MySQLtests.rev.gz

Be sure to check out Sarah's explanations of these stacks here: 
http://www.troz.net/Rev/
plus many other useful stacks (Thank you, Sarah!).

-James


On Oct 18, 2004, at 7: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
>