title: pyodbc.Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnect)')
body: <p>I am trying to connect to a datbase using pyodbc and running into following error,can anyone suggest how to overcome below error?</p>
  
  <p>Installed pyodbc using the following commands</p>
  
  <pre><code>sudo apt-get install unixodbc-dev
  pip install pyodbc
  </code></pre>
  
  <p>Code:-</p>
  
  <pre><code>#!/usr/bin/python
  import pyodbc
  
  server_name='odsdb.qualcomm.com'
  database_name='ODS'
  #cnx = pyodbc.connect("SERVER="+server_name+";DATABASE="+database_name)
  cnx = pyodbc.connect("DRIVER={SQL Server};SERVER="+server_name+";DATABASE="+database_name)
  
  db_cursor = cnx.cursor() 
  
  print "List of tables in DB"
  for row in db_cursor.tables():
      print row.table_name
  print "\n"
  </code></pre>
  
  <p>Error:-</p>
  
  <pre><code>Traceback (most recent call last):
    File "mysql.py", line 7, in &lt;module&gt;
      cnx = pyodbc.connect("DRIVER={SQL Server};SERVER="+server_name+";DATABASE="+database_name)
  </code></pre>