VBA connection string to google Cloud SQL

Hi guys,

So I have a macro that pulls data from a mySQL table from a database on localhost server.

I have another mySQL server which has been successfully connected to a cloud SQL instance in the Google Developers Console.

I would like to take the existing macro I have and rather than pull data from the localhost table, I would like it to pull from a table on the Google server.

The macro code is as follows:

Please Login or Register  to view this content.

It is not as simple as changing Server_Name = GoogleServer (as I've named it in mySQL) or the direct IP address
If I do, I get an error on the cn.Open line saying cannot find server.

For the localhost configuration, I had to check off [Microsoft Active X Data Objects 2.x library] in VBA Reference.
If there a specific one I need to check off to connect to the Google server? ...something about JDBC?

Any help would be appreciated!

So I realized that I did not configure my ODBC driver for the GoogleServer connection. Now that it's properly configured to the right server address, my code now errors out complaining about "unknown database" where before it was saying unknown server.

I think it's syntax in the way I'm specifying the server or database

I have it now as:

Please Login or Register  to view this content.

According to SQL Server connection strings - ConnectionStrings.com
I think it's supposed to be "Connection to a SQL Server Instance"

Please Login or Register  to view this content.

Because on google developers console, my database is listed on a Cloud SQL instance.

I have been unable to modify the connection string so that it accepts my instance "mix-845:test-db" (mix-845 is Authorized App Engine Application)
Such as:

Please Login or Register  to view this content.

My info is as follows:
Server: GoogleServer (xxx.xxx.xxx.xxx)
Instance: mix-845:test-db
Database: GoogleDB

Turns out it was a matter of case-sensitivity.

My database in GoogleServer is actually googleDB, not GoogleDB.

Once fixed, the code works.