On Windows, I get the following error about Data source name not being found. Not sure what it thinks it needs ?
richardschoen opened this issue · 1 comments
richardschoen commented
engine = sa.create_engine("ibmi://USER1:PASSWORD1@SYSI1")
SYSI1 is my host name.
Got this in Windows.
Appears to be looking for a predefined DSN possibly ?
(pyodbc.InterfaceError) ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
(Background on this error at: http://sqlalche.me/e/rvf5)
richardschoen commented
Make sure to have latest IBM i Access ODBC Driver installed. I had an old one from V6R1 that used to work for everything until SQLAlchemy came along. After updating to the last IBM Access ODBC driver all is working as expected.