mssql+aioodbc sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mssql.aioodbc

[biyani701]

While trying to create DB driver with sqlalchemy, i am getting below error

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mssql.aioodbc

I am running on windows 11 and python 3.9.10 aioodbc version 0.5.0

Please suggest how to fix this error

[biyani701]

SQLAlchemy Version is 2.0.19

[gordthompson]

pip install aioodbc

[biyani701]

The issue was resolved after i upgraded sqlalchemy to latest version (2.0.31). is there any minimum required version for aioodbc?

[gordthompson]

is there any minimum required version for aioodbc?

2.0.23

[danrayson]

I had a similar error. Turned out my dialectic was wrong. I was using aiosqlite when it should have been aioodbc (obviously).

Now my connection string looks more like: DATABASE_URL=mssql+aioodbc: