title: Connect to sql server from linux environment using putty private key, sqlalchemy and pyodbc
body: <p>Hi I am trying to read a dataframe from sql server from a linux(ubuntu server).
  The file(gscm.ppk) has the admin keys in it</p>
  <p>I have used the following format to connect to sql server:</p>
  <pre><code>*import urllib
   import pandas as pd
   params = urllib.parse.quote_plus(&quot;DRIVER={SQL Server Native Client 
   11.0};&quot;
                               &quot;SERVER=dagger;&quot;
                               &quot;DATABASE=test;&quot;
                               &quot;UID=ubuntu;&quot;)
   engine = sa.create_engine(&quot;mssql+pyodbc:///?odbc_connect= 
   {}&quot;.format(params))
   df= pd.read_sql('SELECT * FROM ROBALS', engine)*
  </code></pre>
  <p>I keep getting this error:</p>
  <pre><code>sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('01000', &quot;[01000] [unixODBC] 
  [Driver Manager]Can't open lib 'SQL Server' : file not found (0) 
  (SQLDriverConnect)&quot;)
  (Background on this error at: https://sqlalche.me/e/14/dbapi)
  </code></pre>
  <p>I have downloaded the  driver that goes with Ubuntu 20.04</p>