python - 需要帮助将 Flask-SQLAlchemy 连接到 MS SQL Server 2008R2

Question

难以正确连接到数据库:

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

engine = SQLAlchemy.create_engine()

app.config['SQLALCHEMY_DATABASE_URI'] = 'mssql-pyodbc://EVERETT-
PC\\SQLEXPRESS/iNcentDev?trusted_connection=yes'

db = SQLAlchemy(app)
SQLALCHEMY_TRACK_MODIFICATIONS = False

class Payroll(db.Model):
    __tablename__ = 'pay.PayRoll'
    pk = db.Column('id', db.Integer, primary_key=True)
    CreateDate = db.Column('CreateDate', db.DateTime)

Answer 1

这对我有用:

import urllib
params = urllib.parse.quote_plus("DRIVER={SQL Server};SERVER=SERVER_NAME;DATABASE=DB;UID=user;PWD=password")
engine = create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)