Unable to connect to Cluster or SQL endpoint from mac using Simba ODBC connector

Adalberto
Databricks Partner

‎02-10-2022 06:15 AM - last edited on ‎03-21-2025 05:56 AM by Community Manager

DSN configurationError messageHi,

I've been trying to connect to Databricks (cluster or endpoint) from Mac m1 using the simba odbc connector. I followed the instructions in:

https://docs.microsoft.com/en-us/azure/databricks/scenarios/connect-databricks-excel-python-r

https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html

https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html#install-and-configure-the-odbc-driver-...

 

I cannot connect. Attached are the configuration and error message I'm getting. A colleague tried the same instructions on a Windows computer and had no problems.

 

Any suggestion?

Thanks

 

Labels:
Preview file
316 KB
Preview file
54 KB
0 Kudos

Anonymous
Not applicable

‎02-10-2022 08:12 AM

Hello, @Adalberto Garcia Espinosa​. My name is Piper, and I'm a moderator for Databricks. Welcome and thank you for coming to the community with your question. Let's give it a while for the members to respond before we come back. Thanks in advance for your patience. 🙂

0 Kudos

Adalberto
Databricks Partner
In response to Anonymous

‎02-10-2022 08:14 AM

Thank you.

0 Kudos

-werners-
Esteemed Contributor III

‎02-10-2022 11:18 PM

2 things come to mind:

  • either the driver is not yet available for ARM (M1 cpu of your mac)
  • you have a firewall running on your mac

View solution in original post

0 Kudos

Atanu
Databricks Employee
Databricks Employee

‎03-08-2022 06:10 AM

are you using latest connector? also, check your firewall setup for the same.

0 Kudos