# \[unixODBC\] can't open lib /opt/dremio-odbc/lib64/libdrillodbc\_sb64.so

**URL:** <https://community.dremio.com/t/unixodbc-cant-open-lib-opt-dremio-odbc-lib64-libdrillodbc-sb64-so/3765>\
**Category:** Uncategorized\
**Created:** [July 27, 2019, 4:37am UTC](https://community.dremio.com/t/unixodbc-cant-open-lib-opt-dremio-odbc-lib64-libdrillodbc-sb64-so/3765 "2019-07-27T04:37:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hyjy](https://avatars.discourse-cdn.com/v4/letter/h/71e660/32.png) [@hyjy](https://community.dremio.com/u/hyjy)\
**Post date:** [July 27, 2019, 4:37am UTC](https://community.dremio.com/t/unixodbc-cant-open-lib-opt-dremio-odbc-lib64-libdrillodbc-sb64-so/3765/1 "2019-07-27T04:37:33Z")

</div>

Please help on this issue. I have followed the ideas related the similar issues reported before but  
still failed to resolve this. Please help. thanks.

============================================================  
Superset and Dremio integration

ERROR:root:(pyodbc.Error) (‘01000’, “[01000] [unixODBC][Driver Manager]Can’t open lib ‘/opt/dremio-odbc/lib64/libdrillodbc\_sb64.so’ : file not found (0) (SQLDriverConnect)”) (Background on this error at: [http://sqlalche.me/e/dbapi](http://sqlalche.me/e/dbapi))

====== installed ============

ubuntu 18.04  
python 3.6.9

wget [http://download.dremio.com/odbc-driver/1.3.19.1052/dremio-odbc-1.3.19.1052-1.x86\_64.rpm](http://download.dremio.com/odbc-driver/1.3.19.1052/dremio-odbc-1.3.19.1052-1.x86_64.rpm)   
&& alien -i --scripts dremio-odbc-1.3.19.1052-1.x86\_64.rpm

SQLAlchemy 1.2.18  
sqlalchemy-dremio 0.5.0.dev0

===================================

---

<div class="post-metadata">

**Author:** ![Eedupuganti](https://avatars.discourse-cdn.com/v4/letter/e/f04885/32.png) [@Eedupuganti](https://community.dremio.com/u/Eedupuganti)\
**Post date:** [September 27, 2019, 6:09am UTC](https://community.dremio.com/t/unixodbc-cant-open-lib-opt-dremio-odbc-lib64-libdrillodbc-sb64-so/3765/2 "2019-09-27T06:09:20Z")

</div>

Download the rpm file  
wget [http://download.dremio.com/odbc-driver/1.3.19.1052/dremio-odbc-1.3.19.1052-1.x86\_64.rpm](http://download.dremio.com/odbc-driver/1.3.19.1052/dremio-odbc-1.3.19.1052-1.x86_64.rpm)

and Extract the rpm file by the following command  
rpm2cpio dremio-odbc-1.4.2.1003-1.x86\_64.rpm | cpio -idmv

Goto the extracted folder and find the file in this path opt/dremio-odbc/lib64/libdrillodbc\_sb64.so

> > > import pyodbc  
> > > import numpy  
> > > import pandas  
> > > host =‘localhost’  
> > > port = 31010  
> > > uid = ‘username’  
> > > pwd=‘password’  
> > > driver = ‘/home/harsha/opt/dremio-odbc/lib64/libdrillodbc\_sb64.so’