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 [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
