One other possibility: see what happens if you translate 'www.example.com' to a numeric IP address before connecting. You can do this using the hostNameToAddress function.
Cheers, Sarah
James,
Yes, I know these stacks. But the MySQL.tests stack doesn't include the situation where MySQL isn't configured on port 3306...
Thanks anyway, JB
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
_______________________________________________ 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
