i'm trying to figure out the Uri string to connect correctly to db2 using flask with SqlAlchemy.
I've tried with
- db2:///?Server=server&;Port=50000&User=admin&Password=admin&Database=test"
- 'ibm_db_sa+pyodbc400://{username}:{password}@{host}:{port}/{database};currentSchema={schema}
Any clue for the correct value?
Just for the record the correct format (at least for me) is
ibm_db_sa://{username}:{password}@{host}:{port}/{database}
Also you need a few libraries to install via pip in order to work with alembic+flask
In the ibm_db_alembic document is a typo in the description usage, the correct one to import is
from ibm_db_alembic.ibm_db import IbmDbImpl
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments