topic Re: ODBC connection to Databricks on SAS 9.4M6 on Windows in Administration and Deployment

ODBC connection to Databricks on SAS 9.4M6 on Windows

thesasuser — Wed, 07 Aug 2024 13:04:27 GMT

Hello
I am trying to create an ODBC connection to Databricks on AWS using ODBC driver from Databricks on a Windows servers and running SAS 9.4M6. The driver is SparkThriftServer (Spark 1.1 and later).
When I try to test the connection in the ODBC Manager on Windows, I receive the following error message.

FAILED!
[Simba][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.

Wondering if anybody can enlighten on this.
I would appreciate if anybody can share links to (specifically) SAS 9.4/Databricks ODBC connection on Windows environment.
Thanks

Re: ODBC connection to Databricks on SAS 9.4M6 on Windows

SASKiwi — Thu, 08 Aug 2024 02:56:33 GMT

Please post the complete SAS log you used for your test, including the code used. Posting just error messages isn't useful. Also is this the first time you have tried connecting to Databricks from this environment or was it working and now it isn't?

EDIT: Have you just tested a database connection via the Windows ODBC Administrator? If so this isn't a SAS problem. Either your connection details are incorrect and you will need to consult a Databricks administrator to get the correct details, or another possibility is network security rules need changing to allow your database traffic. You will need to consult your IT security folks to check this out.

Re: ODBC connection to Databricks on SAS 9.4M6 on Windows

thesasuser — Fri, 09 Aug 2024 14:45:13 GMT

Thanks @SASKiwi . This is indeed not a SAS problem, but any SAS Admin configuring the ODBC DSN will have to perform this task.
The issue was resolved by selecting Thrift option of HTTP and adding optionally parameters as applicable.

Re: ODBC connection to Databricks on SAS 9.4M6 on Windows

SASKiwi — Sat, 10 Aug 2024 02:52:28 GMT

@thesasuser - Yes, the SAS administrator may do the testing but must have input and help from database administrators.