Re: [google-cloud-sql-discuss] Re: Connecting to SQL Server (Google Cloud) using SQLOLEDB

Thank you, I will continue researching!

On Thu, 2 Apr 2020 at 09:03, 'Michael T (Google Cloud Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

Hello Miller,

I didn't find any internal reference about how you can connect to Cloud SQL Server using SQLOLEDB. Then, I ask you to please refer to the Connecting to Cloud SQL from external applications doc [1] to see the support methods to establish a connection to Cloud SQL.

Stay safe! 

[1] https://cloud.google.com/sql/docs/mysql/connect-external-app

On Wednesday, April 1, 2020 at 8:49:22 PM UTC-4, Miller HS wrote:

Hello google friends!

I have developed an Access application that connects to a SQL Server database (DNSLess via code). With this Covid-19 global pandemic we are looking into alternatives. I created a SQL Server on Google Cloud, database is published and populated but I cannot connect using connection strings and SQLOLEDB Provider but I cannot connect. I have good connection using SSMS and I can browse and run TSQL Scripts no problem, but cannot connect with Access VBA.

Anyone has any ideas? perhaps this is a limitation?

I would appreciate your help. Also like to take the opportunity to encourage everyone to stay home and together we can flatten the curve of this Covid-19 pandemic.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2c74825d-1ed8-41fd-928b-7ccbd2b10621%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAH13VqdG6GF4FPCZ%3DqB_C9XGHoUbOEvEmHmFDxOLUhBS%2BA2%2BUg%40mail.gmail.com.