revOpenDatabase - can't connect

Bob Sneidar bobs at twft.com
Mon Aug 13 18:38:21 EDT 2012


If this is an On-Rev SQL database, you have to enable remote access to the database, and then define which IP addresses you are allowed to connect remotely from. 

Bob


On Aug 13, 2012, at 3:04 PM, Dan Friedman wrote:

> Greetings!
> 
> I am trying to connect to a mySQL database on a couple of remote websites.  I can connect to them via a php script run from the server so tDatabaseAddress is "localhost".  However, every attempt to connect via LiveCode (in the IDE) fails.  I have checked with the host that the address I am using is correct.
> 
> put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
> 
> All params have been confirmed correct.  But, it still fails with this error:
> 
> Unable to connect to the database
> Access denied for user 'xxxx'@'xx.xx.xxx.xxx' (using password: YES)
> 
> or
> 
> Unable to connect to the database
> Can't connect to MySQL server on 'webXX.thehost.com' (60)
> 
> 
> Any advice?
> 
> -Dan
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list