none
ODBC Connection RRS feed

  • Question

  •  We currently are upgrading to SQL 2012

    Product: Microsoft SQL Server Standard (64-bit)

    Version: 12.0.5571.0

    We have an Access Database with ODBC connections that connects many tables with the VBA connection string:

    tbl.Connect = "ODBC;DRIVER={sql server};DATABASE=" & _
                                rsTables!LINKEDDATABASENAME & ";SERVER=" & sServer & ";APP=" & AppName & _
                                ";Trusted_Connection=Yes;NETWORK=DBMSSOCN"

    We are testing the new server and I receive the error below:  I changed drivers to ODBC 11, and then to ODBC 13 but same error persisted.  Any ideas?

    ERROR:

    Microsoft SQL Server Login

    Connection failed:

    SQLState: '01000'

    SQL Server Error: 772

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen

    (SeDoClientHandshake()).

    Connection failed:

    SQLState '08001'

    SQL Server Error: 18

    [Microsoft]ODBC SQL Server Driver]DBNETLIB]SSL Security error

    Monday, August 20, 2018 7:42 PM

All replies

  • That was a good move. The old "sql server" driver is way too old for current use.

    Create your connection in the ODBC applet, and test it.

    The SSL security error seems to indicate the server requires an encrypted connection (like Azure does). Make sure those options are selected when configuring the DSN.

    You can also go to connectionstrings.com and get info about the wide variety of options.


    -Tom. Microsoft Access MVP

    Tuesday, August 21, 2018 1:29 AM
  • Thank you. I'll try it out today.
    Tuesday, August 21, 2018 12:51 PM
  • I now get "Could not find installable ISAM"

    Set myDB = CurrentDb
     Set tdf = myDB.CreateTableDef(strTable)

     With tdf

    .Connect = "Provider=SQLNCLI11;server=" & sServer & ";uid=" & sUser & ";database=" & sDBName & ";Table=" & strTable & ";DataTypeCompatibility=80;"

    Also, added 'Encrypt=yes', but still receiving the error, "Could not find installable ISAM"


    • Edited by Firms Tuesday, August 21, 2018 2:28 PM
    Tuesday, August 21, 2018 2:13 PM