Can we connect google sheet App-Script with AWS RDS Instance ?
401 views
Skip to first unread message
Basant Singh
Dec 20, 2020, 8:05:31 PM12/20/20
to Google Apps Script Community
Hey !
I have seen several post on accessing and connecting Mysql instance with App-Script with the help of jdbc , I do have the code for the same . My question and concern is majorly on, Is this possible that we can connect our google spreadsheet with RDS Mysql Instance in AWS ?
If yes than how as I was trying to do so it gave me an error which says "Exception: Failed to establish a database connection. Check connection string, username and password" . Although I cross verified everything is good, I have tried connecting the same DB from my local machine and I was able to do so .
Permission on firewall is also not the case as I have tried to make my DB publicly accessible as well.So is this even possible that we can connect with AWS RDS instance or not ?
If yes than how as I was trying to do so it gave me an error which says "Exception: Failed to establish a database connection. Check connection string, username and password" . Although I cross verified everything is good, I have tried connecting the same DB from my local machine and I was able to do so .
Permission on firewall is also not the case as I have tried to make my DB publicly accessible as well.So is this even possible that we can connect with AWS RDS instance or not ?
IRVYN CORNEJO
Feb 17, 2021, 6:49:41 PM2/17/21
to Google Apps Script Community
Hello!
It is possible to do it the only thing is to select in version 5.7 .. of MySQL. With that I can do it without problems.
Reply all
Reply to author
Forward
0 new messages