Can't connect to MySQL server using revOpenDatabase
jbv.silences at Club-Internet.fr
Mon Oct 18 07:51:54 CDT 2004
Yes, I know these stacks.
But the MySQL.tests stack doesn't include the situation
where MySQL isn't configured on port 3306...
> 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:
> Be sure to check out Sarah's explanations of these stacks here:
> plus many other useful stacks (Thank you, Sarah!).
> 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
> use-revolution mailing list
> use-revolution at lists.runrev.com
More information about the use-livecode