If you are getting the following error:
ODBC error
Connect failed: SQL State: '01000'
SQL Server Error: 10054
[Microsoft] ODBC SQL Server Driver][DBNETLIB]ConnectionRecord(recv().
Connection failed: SQLState:'08s01' SQL Server Error 11
[Microsoft][ODBC SQL Server Driver]DBNETLIB]General network error. Check your network documention.
SQL Connect error
Cannot connect to <servername>
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error:0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)
The specified network name is no longer available
Errors in the pre-login handshake are typically to do with certificates.
Access SQL Connect uses certificates and can be used as a proxy service for communications between Third party apps and Access products including via ODBC connections.
β
Please double-check and confirm that the latest certificate and key files are being used.
