[unixODBC] can't open lib /opt/dremio-odbc/lib64/libdrillodbc_sb64.so

1

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)

====== 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
&& alien -i --scripts dremio-odbc-1.3.19.1052-1.x86_64.rpm

SQLAlchemy 1.2.18
sqlalchemy-dremio 0.5.0.dev0

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

2

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

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’