# Dremio ODBC connection error

**URL:** <https://community.dremio.com/t/dremio-odbc-connection-error/7370>\
**Category:** Uncategorized\
**Created:** [April 30, 2021, 12:28pm UTC](https://community.dremio.com/t/dremio-odbc-connection-error/7370 "2021-04-30T12:28:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ayush.goyal](https://avatars.discourse-cdn.com/v4/letter/a/c6cbf5/32.png) [@Ayush.goyal](https://community.dremio.com/u/Ayush.goyal)\
**Post date:** [April 30, 2021, 12:28pm UTC](https://community.dremio.com/t/dremio-odbc-connection-error/7370/1 "2021-04-30T12:28:27Z")

</div>

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](https://docs.dremio.com/client-applications/python/) 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?

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [May 1, 2021, 5:39am UTC](https://community.dremio.com/t/dremio-odbc-connection-error/7370/2 "2021-05-01T05:39:21Z")

</div>

@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

---

<div class="post-metadata">

**Author:** ![mendeel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mendeel/32/2636_2.png) [@mendeel](https://community.dremio.com/u/mendeel)\
**Post date:** [May 7, 2021, 12:12pm UTC](https://community.dremio.com/t/dremio-odbc-connection-error/7370/3 "2021-05-07T12:12:30Z")

</div>

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](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/a9981a1de2c1a08ccc45a2b4cbd0fd0f734cdd59.png)