title: Reading table into pandas using sqlalchemy from SQL Server
body: <p>I've been at this for many hours, and cannot figure out what's wrong with my approach.  I'm trying to read a table into pandas using sqlalchemy (from a SQL server 2012 instance) and getting the following error: </p>
  
  <p><code>DBAPIError: (Error) ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)") None None</code></p>
  
  <p>I'm using the following code: </p>
  
  <pre><code>import sqlalchemy as sql
  
  from sqlalchemy import create_engine
  
  import pyodbc
  
  pyodbc.connect('DSN=MYDSN;UID=User;PWD=Password')
  </code></pre>
  
  <p>Which returns: </p>
  
  <pre><code>&lt;pyodbc.Connection at 0x10a26a420&gt;
  </code></pre>
  
  <p>Which I think is good.  Then when I run the following: </p>
  
  <pre><code>connectionString = 'mssql+pyodbc://User:Password@IPAdress/Database'
  engine = sql.create_engine(connectionString)
  
  pd.read_sql("ecodata", engine)
  </code></pre>
  
  <p>I get the following error mentioned above.  </p>
  
  <p>Is there something wrong with my driver setup?  I've been wrestling with the driver setup for days and thought I had it beat.</p>
  
  <p>Any help is greatly appreciated.</p>