sandman2 icon indicating copy to clipboard operation
sandman2 copied to clipboard

Published 20 hours ago • verified publisher icon jeffknupp

About MS SQL

Open michliu opened this issue 2 years ago • 1 comments

How to connect to MS SQL ? DB_TYPE=? / DB_DRIVER=?

michliu avatar May 19 '22 02:05 michliu

DB_TYPE=mssql and DB_DRIVER=pymssql

You can connect to your SQL Server using:

sandman2ctl mssql+pymssql://sa:PASSWORD@localhost:1433/master

I had to install sandman2, pymssql and upgrade the SQLAlchemy version

pip install sandman2 pymssql
pip install Flask-SQLAlchemy==2.5.1

educostadev avatar Dec 21 '22 17:12 educostadev