We have previously been able to access our Databricks cluster in R using ODBC but it stopped working a couple of months ago and now i can't get it to connect.
I've downloaded the latest drivers and added the right information in odbc/odbcinst files but i still get an error when i try to connect.
Below is the code i'm running and the error i get:
conn <- odbcConnect("Databricks")Warning messages:
1: In RODBC::odbcDriverConnect("DSN=Databricks") :
[RODBC] ERROR: state HY000, code 1170, message [unixODBC][Simba][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.
2: In RODBC::odbcDriverConnect("DSN=Databricks") : ODBC connection failedAnd here's the details from my odbc.ini file:
[ODBC Data Sources]
Databricks=Databricks ODBC Connector
[Databricks]
Driver=Simba Spark ODBC Driver 64-bit
Server=our_server.com
HOST=our_server.com
PORT=443
SparkServerType=3
ThriftTransport=2
SSL=1
AuthMech=3
UID=token
PWD=my_token
And below is from the odbcinst file:
[Simba Spark ODBC Driver 64-bit]
Description=Simba Spark ODBC Driver (64-bit)
Driver=/opt/simba/spark/lib/64/libsparkodbc_sb64.so
We have no issues on the same server to access the cluster from Python using the databricks-sql-connector so there should not be any issues with connectivity.
Any suggestions?
