title: Linux Open Suse "pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)")"
body: <p>I know this question was asked before but I never really got a proper answer that would solve my problem. I am trying to connect to a SQL server on a windows machine from a linux Open Suse12.4 machine.</p>
  
  <pre><code>pyodbc.connect('DRIVER={SQL Server};SERVER=servername;DATABASE=dbname;UID=userid;PWD=password')
  </code></pre>
  
  <p>the exact error I got was as below:</p>
  
  <blockquote>
    <p>pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)")</p>
  </blockquote>
  
  <p>and below is my odbcinst.ini file :</p>
  
  <pre><code>[Easysoft ODBC-SQL Server]
  Driver=/usr/local/easysoft/sqlserver/lib/libessqlsrv.so
  Setup=/usr/local/easysoft/sqlserver/lib/libessqlsrvS.so
  Threading=0
  FileUsage=1
  DontDLClose=1
  UsageCount=2
  
  [Easysoft ODBC-SQL Server SSL]
  Driver=/usr/local/easysoft/sqlserver/lib/libessqlsrv_ssl.so
  Setup=/usr/local/easysoft/sqlserver/lib/libessqlsrvS.so
  Threading=0
  FileUsage=1
  DontDLClose=1
  UsageCount=2
  </code></pre>