topic Re: ODBC connection issue Simba 64 bit in Databricks Free Edition Help

ODBC connection issue Simba 64 bit

Rajeshwar_Reddy — Fri, 10 Jan 2025 18:00:46 GMT

Hello All

Am getting the below error when trying to create ODBC DSN Simba 64 in local system to connect Databricks Server using the token and enabled SSL System trust store & Thrift Transport: HTTP.any helping hand really appreciated .

[Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: Bad Status: Unrecognized response with no error message header. Status code: 404.

Re: ODBC connection issue Simba 64 bit

Alberto_Umana — Fri, 10 Jan 2025 18:08:25 GMT

Hi @Rajeshwar_Reddy,

Thanks for your post! can you sure your connection string, and cover sensitive information?

Re: ODBC connection issue Simba 64 bit

Rajeshwar_Reddy — Fri, 10 Jan 2025 18:34:32 GMT

Hi Alberto_Umana

My connection string is perfect , what do you want me to cover here ?

Re: ODBC connection issue Simba 64 bit

DougJames — Fri, 10 Oct 2025 19:44:24 GMT

Hi @Alberto_Umana,

I'm running into the same issue this connection string works on one server but is failing with this error on another.

Driver=Simba Spark ODBC Driver;Host=nike-sole-react.cloud.databricks.com;Port=443;SparkServerType=3;Schema=default;SSL=1;AuthMech=11;Auth_Flow=0;ThriftTransport=2;Auth_AccessToken=dapixxxxxxxxxxxxxx;

Re: ODBC connection issue Simba 64 bit

DougJames — Fri, 17 Oct 2025 14:13:22 GMT

Solved for my case. Still not sure why/how it was working on one server but not the other.

Final fix was to add HTTPPath value to the Connection String I listed above.