Connect Flask App to MSSQL database.

[Sekelo77]

Hi,

Can you please assist with some advice or guidiance on how to connect my flask application, to our mssql server/database.

Could be a Youtube videos, or any online study material.

I have successfuly build my application and is working fine with sqlite, but my company uses MSSQL Server which is were I need to connect it to, I do have solid background on executing SQL statements, (T-SQL), but my request right is anyone with usefull guideline or information/walk through on how I connect the flask app to our inhouse db, would appreciate that.

Thank you

[v-achippa · Accepted solution]

Hi @Sekelo77,

Thank you for reaching out to Microsoft Fabric Community.

Based on your requirement, since the application is already working with sqlite, you only need to update the database connection. The recommended approach is to use SqlAlchemy with the pyodbc driver, which works correctly with sql server in production environments. Please follow below steps:

• Install pyodbc and ensure the ODBC Driver for sql server is installed
• Update your connection string to use mssql+pyodbc
• Your existing models and queries can remain the same

You can also execute raw T-Sql queries if needed using SqlAlchemy.

Thanks and regards,

Anjan Kumar Chippa

[Sekelo77]

Thank You.