Re: revOpenDatabase - can't connect

2012-08-14 Thread Martin Koob
Also with on-rev and cPanel when you enable remote access you specify the IP address you will be connecting from. If your service provider changes your IP address then you have to go into cPanel and change the IP address for remote access to the new one. Martin -- View this message in

Re: revOpenDatabase - can't connect

2012-08-14 Thread Matthias Rebbe
If i remember right in that case you could enter %.%.%.% as a wildcard ip address, but this would accept connections from every ip address. Regards, Matthias Am 14.08.2012 um 14:30 schrieb Martin Koob mk...@rogers.com: Also with on-rev and cPanel when you enable remote access you specify

Re: revOpenDatabase - can't connect

2012-08-14 Thread Bob Sneidar
You can also enter wildcards. If you figure out the provider's subnet, just set it for a likely range, or get a fixed IP from your provider if they provide it. Frankly though, I think using remote SQL makes sense only for development. Knowing what I know, I don't think I would ever deploy an

Re: revOpenDatabase - can't connect

2012-08-14 Thread Bob Sneidar
Right, and if your data has any value at all I would not do that. Something like 10.45.2.% might do the trick, but provider subnets are rarely classful, meaning the mask is either 255.0.0.0, 255.255.0.0, or 255.255.255.0. There is actually a bit more to it than that, but this is the general

revOpenDatabase - can't connect

2012-08-13 Thread Dan Friedman
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

Re: revOpenDatabase - can't connect

2012-08-13 Thread Matthias Rebbe
Dan, most server do not allow remote access for security reasons. Only access from local scripts are allowed in that case. So you have to check if you can enable remote db access on that servers. Regards, Matthias Am 14.08.2012 um 00:04 schrieb Dan Friedman d...@clearvisiontech.com:

Re: revOpenDatabase - can't connect

2012-08-13 Thread Bob Sneidar
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