Can't connect to MySQL server using revOpenDatabase
sarahr at genesearch.com.au
Mon Oct 18 18:52:56 CDT 2004
It should work if you enter 'www.example.com:5432' in the address
field, instead of just 'www.example.com' although I have never tried
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.
> 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 -
>> I would suggest trying Sarah's MySQL Rev code. It really helped me
>> 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
>>> 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 ?
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
> use-revolution mailing list
> use-revolution at lists.runrev.com
More information about the use-livecode