title: Using pyodbc cause error: Data source name not found and no default driver specified
body: <p>I'm using pyodbc to connect SQL Server. I had created connection string like this:</p>
  
  <pre><code>from sqlalchemy import Table, Column, databases, Integer, String, ForeignKey, create_engine
  from sqlalchemy.ext.declarative import declarative_base
  from sqlalchemy.orm import session
  engine = create_engine('mssql+pyodbc://sa:123@localhost/TrainQuizDB')
  engine.connect()
  </code></pre>
  
  <p>TrainQuizDB is database name that I created in Sql Server.</p>
  
  <p>For more information I have windows 8.1 64bit and I installed python version 3.5.1 32bit and I downloaded pyodbc from <a href="http://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc" rel="nofollow noreferrer">http://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc</a> (pyodbc-3.0.10-cp35-none-win32.whl).
  But when I try to connect it cause this error:</p>
  
  <pre><code>sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
  </code></pre>
  
  <p>Also I have tested the connection In ODBC Data sources and it was successful.</p>
  
  <p><a href="https://i.stack.imgur.com/BJdy7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BJdy7.png" alt="ODBC Connection"></a></p>