Pyodbc: Specify Location Of Driver In Windows

Is it possible to specify where pyodbc looks for the SQL driver? I have a python application which needs the 'SQL Native Client 10.0' driver to connect to a SQL database. So my co

Solution 1:

If your application actually uses features specific to

Driver={SQL Server Native Client 10.0}

then that driver needs to be installed properly on the client system. However, if you just need basic connectivity to SQL Server then

Driver={SQL Server}

is included with a standard Windows install and is available to both 32-bit and 64-bit applications.