I can't find driver = '/Library/Dremio/ODBC/lib/libdrillodbc_sbu.dylib' after driver upgrade

1

Hello everyone ,

I am running into this issue, I accidentally installed the latest version odbc driver 1.5.4 on my mac, now I can’t this find "Dremio folder in my Library path as well as this driver /Library/Dremio/ODBC/lib/libdrillodbc_sbu.dylib’

I greatly appreciate contribution on how to find this driver path. Or has dremio change destination for dremio driver installation for mac?

this is my broken code

def conn_util():
    try:
        host = ''
        port = ''
        uid = ' '
        pwd = ''
        driver = '/Library/Dremio/ODBC/lib/libdrillodbc_sbu.dylib'
        cnxn = pyodbc.connect("Driver={};ConnectionType=Direct;HOST={};PORT={};AuthenticationType=Plain;UID={};PWD={}".format(
        driver, host, port, uid, pwsd), autocommit=True)

        return cnxn

    except:
        logging.debug("check connection variable")
2

@iskidet I find it on my mac under the same folder, which version of Mac is this? Do you see this file? /Library/Dremio/ODBC/lib/libdrillodbc_sbu.dylib

% pwd
/Library/Dremio/ODBC/lib
balajiramaswamy@Balajis-MacBook-Pro lib % ls -ltrh
total 191208
-rw-r--r--  1 balajiramaswamy  staff   119B May 12  2021 dremio.drillodbc.ini
-rwxr-xr-x  1 balajiramaswamy  staff   203K Sep 13 12:05 cacerts.pem
-rwxr-xr-x  1 balajiramaswamy  staff   880B Sep 13 12:05 DrillODBC.did
-rwxr-xr-x  1 balajiramaswamy  staff    93M Sep 20 10:16 libdrillodbc_sbu.dylib
3

My mac version is 11.2.3 (BigSur) and I don’t see the file path

Screen Shot 2022-02-08 at 8.55.28 AM
Screen Shot 2022-02-08 at 8.55.28 AM302×663 44.7 KB

image
image1143×346 19.7 KB

4

@iskidet

/Library and ~/Library are different. It looks like your screenshot is from ~/Library.

Try this to see if the driver is installed by running: ls -ltrh /Library/Dremio/ODBC/lib/libdrillodbc_sbu.dylib

image
image1569×634 129 KB

1 Like
5

Thank you that solves my 12hours issue. I never knew they were different :grinning: