Hello to all,
I'm having trouble connecting a Google Spreadsheet to a local MySql database in one of our offices.
Error displayed by Google is: A connection could not be established with the database, check user password and connection string.
This is the code i'm trying:
var connectionstring = "jdbc:mysql://public_ip:9002/db_name";
var conn = Jdbc.getConnection(connectionstring, "user", "password");
var stmt = conn.createStatement();
Other scenario considerations:
1. The Firewalls incoming 9002 port is being forwarded correctly into the 3306 on the local db server.
2. user and password work fine since Remote Workbench connections are possible.
3. I've even tied up a remote MS Excel sheet to the db and it works with the same url and login information
4. No IP incomming connections are being blocked explicitly, you can call the port from whatever ip you want and you will be redirected to the internal server
Does somebody have any guidance on what to try?
i've been fighting for over a week!
Thanks to all