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:
Error:
Traceback (most recent call last):
  File "/home/pi/Desktop/FYProject/Main.py", line 171, in <module>
    main()
  File "/home/pi/Desktop/FYProject/Main.py", line 72, in main
    pwd='Password')
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}',
                      server='servername',
                      database='databasename',
                      uid='UserID',
                      pwd='Password')
Posted
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