[Solved] 09-12-2014, 01:30 PM
(09-12-2014, 01:07 PM)Genesis Wrote: OK, this is early days and I could be off the mark, but I've got a theory. Is your IP a dynamic IP. Sort of makes sense you have to have a static IP for the distance connection to work because you have to have a white listed IP (you doing the white listing). Have you tried a proxy IP?
Check the literature here - quite informative for recommending strings for your coding:
The Google Apps Script runs on Google's servers, not my machine and thus, the script attempts to establish a connection between database and Google's servers. I guess I cannot extract the IP addresses of all the Google servers and so I have added a "%" and - additionally, however little sense it has - a "%.google.com" wildcards. This way, I do not have to manually set all the possible Google's addresses.
I will try to connect to the database from a local machine with some software now, just to ensure i am using the very correct credentials.
@Genesis Okay, I have attempted to connect to the database using HeidiSQL from my local machine. Did not succeed. This is what I did receive:
I have no idea what should I try to do now, what I do have, though, is another question: could you check (at least using the portable version of HeidiSQL from here) if you are able to connect to your database if you have any located here, on Gigarank? To ensure that it is possible to do on Gigarank.