June 29, 2017 at 8:15 am
Hello experts,
I am trying to set up a DSN-less connection using MS Access as a front end that uses VBA to dynamically link tables from a SQL Server 2016 back end. I posted here first because this is more of an ODBC/JDBC programming question and the MS Access forum does not seem to get much activity.
I am working on a connection to a SQL Server 2016 server that requires the password to be encrypted for the JDBC connection example below. Does anyone know if there is a way to specify an ODBC connection with a SQL Server driver to encrypt the password?
I tried the page https://www.connectionstrings.com/sql-server-native-client-11-0-odbc-driver/ but could not find a parameter that does this. That page does list a parameter called "Encrypt data sent over network" but I'm not sure if that is the same thing as encrypting just the password as the JDBC "ssl=authenticate" seems to indicate.
JDBC URL
jdbc:sqlserver://myserver:1433;databaseName=myDB;ssl=authenticate
Driver Class
com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name
Microsoft JDBC Driver 4.1 for SQL Server
Thanks for any help.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply