Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Connecting to Cloud SQL Server database
160 views
Skip to first unread message
Gussie
Apr 1, 2020, 4:52:04 PM4/1/20
to
I have an Access application that I have been using for the past 3 years and it uses Microsoft SQL Server database. The access is just for the forms not even queries. Everything is done via Server-side TSQL and code (local database). I use SQLOLEDB provider; build my connection string and I connect to SQL.
With Google Cloud SQL Server I cannot connect, perhaps I am missing some settings in the Cloud SQL Server?
Help...
With Google Cloud SQL Server I cannot connect, perhaps I am missing some settings in the Cloud SQL Server?
Help...
Ron Weiner
Apr 1, 2020, 8:31:42 PM4/1/20
to
Gussie brought next idea :
Might be helpfull if you shared what dosent work by showing us what
your non working connection string is.
Rdub
--
This email has been checked for viruses by AVG.
https://www.avg.com
your non working connection string is.
Rdub
--
This email has been checked for viruses by AVG.
https://www.avg.com
Gussie
Apr 1, 2020, 9:30:03 PM4/1/20
to
This is the connection string
Provider=SQLOLEDB;SERVER=XX4.X98.XX1.X9;DATABASE=XXXX;uid=sqlserver;pwd=jhs^s#@$SDSF
Here is the error I get:
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.
It should be pretty straight forward but I can't get it work. Thank you for replying...
Ron Weiner
Apr 2, 2020, 4:19:05 PM4/2/20
to
Gussie presented the following explanation :
Have you tried any other providers? I have been using the Sql Native
Client driver for years in Access to connect to a variety of sql
servers. Something like:
Driver={SQL Native
Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
I am currently using that specific provider to connect to a Sql Server
that is being hosted by Amazon Web Services. That connection is being
used both to link tables/queries, and VBA code things. Haven't had a
lick of a problem.
There is a VERY good web site resource for connection strings at
https://www.connectionstrings.com/ I think that if you spend a little
time there you will likely find something that works.
Rdub
Client driver for years in Access to connect to a variety of sql
servers. Something like:
Driver={SQL Native
Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
I am currently using that specific provider to connect to a Sql Server
that is being hosted by Amazon Web Services. That connection is being
used both to link tables/queries, and VBA code things. Haven't had a
lick of a problem.
There is a VERY good web site resource for connection strings at
https://www.connectionstrings.com/ I think that if you spend a little
time there you will likely find something that works.
Rdub
Gussie
Apr 7, 2020, 7:20:03 AM4/7/20
to
Thank you for your help. Sorry I didn't got back sooner. It's been very busy lately. I did connect with SQLNCLI11 provider so we are good. I totally forgot about the different providers available. Anyways I would have not solve it without your help. Cheers! stay safe.
0 new messages