[Tutor] Error while connecting to SQL Server using Python

[Mats Wichmann]

On 7/22/22 11:27, Dennis Lee Bieber wrote:
> On Fri, 22 Jul 2022 20:06:24 +0530, Sachit Murarka
> <connectsachit at gmail.com> declaimed the following:
> 
>> Facing below error while using pyodbc to connect to SQL Server.
>>
>> conn = pyodbc.connect( pyodbc.Error: ('01000', "[01000] [unixODBC][Driver
>> Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0)
>> (SQLDriverConnect)")
>>
>> Can anyone pls suggest what could be done?
>>
> 
> 	What OS? (the "unixODBC" suggests it may be some variant of Linux,
> but...).

If it *is* Linux, check that the driver you're trying to use is listed
in /etc/odbcinst.ini.  There are a bunch of defaults there, but I think
the Microsoft ODBC drivers, of which there about two zillion different
versions, are not among them.

There should be documentation on that topic, if that is indeed the issue.