pyodbc.Error: ('01000',"[01000][unixODBC][Driver Manager] can't open lib '/usr/lib/odbc/libtdsodbc/so' : file not Found (0) (SQLDriverConnect)")

Question

I have followed Querying MSSQL from RaspberryPi to install FreeTDS on my Pi4. However, the error below occurs. ['FreeTDS']

Traceback (most recent call last ):

File "/home/pi/Downloads/test1.py" , line 14,

cnxn = pyodbc.connect(cnxn_str)

pyodbc.Error: ('01000', "[01000] [unixODBC] [Driver Manager]

can't open lib '/usr/lib/odbc/libtdsobc.so' : file not found (0) (SQLDriverConnect)")

Answer 1

Edit /etc/odbcinst.ini

If the paths for Driver and Setup do not work in your installation, you can find where these files are located by running find / -name "libtds*".