How to resolve SSL_connect error when VPN is enabled

[pavan_yndpl]

I am trying to connect to Databricks using ODBC protocol with Simba Driver DSN. I am able to successfully connect and access the data when our corporate VPN is turned OFF. but when it's turned ON , I am getting the following error "[Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect:"
how to resolve this ?

[Walter_C]

The error you are encountering, " (14) Unexpected response from server during a HTTP connection: SSL_connect:", when trying to connect to Databricks using the ODBC protocol with the Simba Driver DSN while the corporate VPN is turned on, is likely related to SSL certificate verification issues

Here are some steps you can take to resolve this issue:

1. Check SSL Certificate Configuration:

   • Ensure that the SSL certificates are correctly configured. You might need to disable SSL certificate verification if you are using self-signed certificates or if there are issues with the certificate chain.
   • You can do this by setting the AllowSelfSignedServerCert option to 1 and the AllowHostNameCNMismatch option to 1 in your DSN configuration. This can be done in the simba.sparkodbc.ini file or through the ODBC Data Source Administrator.

2. Disable Certificate Revocation Check:

   • If the issue persists, you can try disabling the certificate revocation check by setting the CheckCertRevocation option to 0.

3. Use System Trust Store:

   • Ensure that the UseSystemTrustStore option is set to 1 if you want to use the system's trust store for SSL verification.