Dremio ODBC connection error

1

Hi,

I have installed dremio on kubernetes in server and i am using mac. When I am trying to connect to dremio odbc connection through mac. I am getting below error
pyodbc.OperationalError: ('08001', '[08001] [Dremio][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[Port]} (10380) (SQLDriverConnect)')

I am following Dremio and has also installed odbc driver for mac

>>> import pyodbc
>>> drivers = [item for item in pyodbc.drivers()]

>>> drivers

['Dremio Connector']
>>> host = "<server hostname"

>>> port = 31857

>>> uid = "ayush.goyal"

>>> pwd = "myloginpassword"


>>> driver = drivers[-1]

>>> con_string = f'DRIVER={driver};SERVER={host};ORT={port};UID={uid};PWD={pwd}'

>>> cnxn = pyodbc.connect(con_string)

Traceback (most recent call last):

File "<stdin>", line 1, in <module>

pyodbc.OperationalError: ('08001', '[08001] [Dremio][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[Port]} (10380) (SQLDriverConnect)')

How can i resolve this? Do i have to installed dremio odbc connector in mac or in the pod where dremio executor is running?

2

@Ayush.goyal If you are trying to connect to a Dremio server from your local mac, then the ODBC client should be installed on your mac

1 Like
3

Your error message clearly states that the PORT parameter is missing. Your code says ORT instead of PORT, so I guess you just need to fix your code.

image
image1388×112 8.47 KB

1 Like