Click here to Skip to main content
14,449,842 members
Rate this:
Please Sign up or sign in to vote.
I am trying to access SQL server from raspberry pi using the following query but i am unable to do that. and python shell return error:
Traceback (most recent call last):
  File "/home/pi/Desktop/FYProject/", line 171, in <module>
  File "/home/pi/Desktop/FYProject/", line 72, in main
pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server 11.0.5058' : file not found (0) (SQLDriverConnect)")

What I have tried:

conn = pyodbc.connect(driver='{SQL Server}',
Updated 5-Jul-19 9:54am

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Can't open lib 'SQL Server 11.0.5058': file not found (0)")
The error says it all: PYODBC cannot find the Sql Server driver.

Perhaps this article can help you get it installed/corrected:
Connect to MSSQL using FreeTDS / ODBC in Python. · GitHub[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100