Re: Google Apps Script JDBC Service and Google Cloud SQL

Sorry, I didn't realize you were talking about allowing access by other users from Apps Script.

Unfortunately the only way to allow them access at the moment is to give them access to the project. See:

https://developers.google.com/cloud-sql/docs/access_control#individuals

We understand its not an ideal solution and are looking at alternatives

J

On Fri, Nov 16, 2012 at 8:55 AM, Jacob van den Berg <jacobvdb@lagaroo.com.br> wrote:

+Joe 

The link you send, that informantion would also account for the jdbc connection from a G Apps Script?

As in the documentation it is written :

"Scripts that execute as the active user will not be able to connect to the database unless the end users are also members of the project. That may not always be possible or desirable, especially for consumer-facing web apps, and we are working on alternative solutions."

Thanks for your attention! 

Jacob 

On Friday, November 18, 2011 3:20:24 PM UTC-2, Laurent Rousset wrote:

Hi,

First of all : Google Cloud SQL is great !

While Google Cloud SQL is a MySQL implementation, is it possible to access an instance of a domain "xxxxx.com" from a Google Apps Script hosted by a SpreadSheet in the same domain ? Using the Google Apps Script JDBC Service.

I tried but it seems not working.

Any help ? It would be a great feature to build richer Google Apps Script application.

Regards

Laurent

--
Joe Faith | Product Manager | Google Cloud