ODBC connection for SQL Server that requires encrypted password

• webrunner

  SSC-Dedicated

  Points: 32014

  More actions

  June 29, 2017 at 8:15 am

  #146464

  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