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
