Pandas does not like using the PyODBC connection and gives this warning:
UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.
data = pd.read_sql(sql, cnxn)
Pandas does not like using the PyODBC connection and gives this warning:
UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.
data = pd.read_sql(sql, cnxn)