0

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)")

MyatKaung
  • 9
  • 2
  • Which instructions? There is no accepted answer at the SO question you linked. – AlwaysLearning Sep 20 '22 at 03:44
  • Please don't post pictures of text, copy the original text to your question. And definitely don't take pictures of the screen with a camera. – James Z Sep 20 '22 at 04:20
  • Yes I have changed already. – MyatKaung Sep 20 '22 at 06:35
  • The `/usr/lib/odbc/libtdsobc.so` path seems to be incorrect. Please [Edit](https://stackoverflow.com/posts/73781324/edit) your question to include the contents of `/etc/odbcinst.ini`. – AlwaysLearning Sep 21 '22 at 03:49
  • Yes I have got it. The library location in my raspberry pi is different from the tutorial and I don't know how to find that location but now I have got it. Thanks – MyatKaung Sep 21 '22 at 04:33

1 Answers1

0

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*".

MyatKaung
  • 9
  • 2