How can I access MS SQL from raspberry pi?

See more:

SQL

Raspberry-Pi

Python3.6

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