title: Getting error while creating pypyodbc connection python
body: <p>i am trying to connect a database in sql server using pypyodbc in ubuntu.</p>
  
  <p>below is my code:</p>
  
  <pre><code>import pandas as pd
  import pypyodbc
  host = "servername"
  username = "sa"
  password = "sa@12"
  database = "dbname"
  
  try:
      conn = pypyodbc.connect("DRIVER={SQL Server};SERVER=%s;UID=%s;PWD=%s;DATABASE=%s") % (host, username, password, database)
      print ("SUCCESS")
  except Exception as e:
      print ("Error: " + str(e))
  </code></pre>
  
  <p>but i am getting this error.</p>
  
  <blockquote>
    <p>Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified')</p>
  </blockquote>
  
  <p>Is there a way to solve this?</p>