How to use OS Env Vars in odbcinst.ini file

1

Hi, I am trying to use environment variables inside my odbc.ini and odbcinst.ini files, but they don’t get picked up

odbcinst.ini:

[Dremio ODBC Driver 64-bit]
Description=Dremio ODBC Driver(64-bit)
Driver=$(DREMIODRIVER)

I am trying to reference this DREMIODRIVER env var, but it isn’t found for some reason

pyodbc.Error: (‘01000’, u"[01000] [unixODBC][Driver Manager]Can’t open lib ‘$(DREMIODRIVER)’ : file not found (0) (SQLDriverConnect)")

2

I have tried many variations of this

${DREMIODRIVER}
$DREMIODRIVER
%(DREMIODRIVER)
%(DREMIODRIVER)s

3

@aaltadonna45

Currently this is not possible

Thanks
Bali

1 Like
4

There is nothing I can edit in the Dremio python code to inject OS vars into the configs?