Re: remote mySQL connection not working

2011-02-22 Thread tkuyp...@telenet.be
Hi Terry, Will give it another try, it must be something like that. Thanks! Met vriendelijke groeten, Ton Kuypers ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscripti

Re: remote mySQL connection not working

2011-02-22 Thread Terry Judd
Ton - I'd still suspect a problem with the variable or the variable name. Invisible characters have a habit of creeping into the script editor if your fingers are as clumsy as mine. Try deleting the relevant bits of code and retyping them. I make mySQL connections all the time using variables (as

Re: remote mySQL connection not working

2011-02-22 Thread tkuyp...@telenet.be
I put the variables into the message-box and copied them to my code from there... So sorry, the variables are correct, got no idea why this doesn't work. But because there is nu user-interaction required to set these parameters, I just entered them in the code :-) Met vriendelijke groeten, Ton

Re: remote mySQL connection not working

2011-02-22 Thread Bob Sneidar
Step through your code and make sure your variables are what you expect. They probably are not. Bob On Feb 22, 2011, at 6:42 AM, tkuyp...@telenet.be wrote: > Hi Mark, > > No, that's ok, I do have remote access. > Did some more testing and the plot thickens... > > When I use put "revOpenDatab

Re: remote mySQL connection not working

2011-02-22 Thread tkuyp...@telenet.be
Hi Mark, No, that's ok, I do have remote access. Did some more testing and the plot thickens... When I use put "revOpenDatabase("mysql", "myFakeURL.com", "DatabaseName", "UserName", "Password") into dbResult" it works fine. But when I use variables (put revOpenDatabase("mysql",dbAddr,dbName,dbU

Re: remote mySQL connection not working

2011-02-22 Thread Mark Schonewille
Hi Ton, Before you do anything else, call your ISP and ask if a direct connection is allowed. Very many ISP's only allow connections from applications running on the same server (such as Apache and Perl). If your ISP does allow direct remote connections, make sure that you have set up a userna

remote mySQL connection not working

2011-02-22 Thread tkuyp...@telenet.be
A very strange thing is happening when connecting to a mySQL database. going to my localhost on my Mac, no problems logging in, but when I try to connect to my remote mySQL server, I keep on getting the error "Access denied for user 'intelli-pubs'@'94-224-36-65.access.telenet.be' (using password: