Breaking News: Grepper is joining You.com. Read the official announcement!

flask connect to mssql

S3NS4 answered on July 21, 2022 Popularity 10/10 Helpfulness 2/10

answer flask connect to mssql

related flask connect to mysql

flask connect to mssql

Comment

# Python 2.x
import urllib
params = urllib.quote_plus("DRIVER={SQL Server Native Client 10.0};SERVER=dagger;DATABASE=test;UID=user;PWD=password")
engine = create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)

# Python 3.x
import urllib
params = urllib.parse.quote_plus("DRIVER={SQL Server Native Client 10.0};SERVER=dagger;DATABASE=test;UID=user;PWD=password")
engine = create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)


# using the above logic I just did the following
params = urllib.parse.quote_plus('DRIVER={SQL Server};SERVER=HARRISONS-THINK;DATABASE=LendApp;Trusted_Connection=yes;')
app.config['SQLALCHEMY_DATABASE_URI'] = "mssql+pyodbc:///?odbc_connect=%s" % params

Popularity 10/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: connect flask python sql-server

Link to this answer
Share Copy Link

Contributed on Nov 14 2022

S3NS4

0 Answers Avg Quality 2/10

Closely Related Answers

flask connect to mysql

Comment

from flask import Flask,render_template, request
from flask_mysqldb import MySQL
 
app = Flask(__name__)
 
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = ''
app.config['MYSQL_DB'] = 'flask'
 
mysql = MySQL(app)
 
@app.route('/form')
def form():
    return render_template('form.html')
 
@app.route('/login', methods = ['POST', 'GET'])
def login():
    if request.method == 'GET':
        return "Login via the login Form"
     
    if request.method == 'POST':
        name = request.form['name']
        age = request.form['age']
        cursor = mysql.connection.cursor()
        cursor.execute(''' INSERT INTO info_table VALUES(%s,%s)''',(name,age))
        mysql.connection.commit()
        cursor.close()
        return f"Done!!"
 
app.run(host='localhost', port=5000)

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.askpython.com

Tags: connect

Link to this answer
Share Copy Link

Contributed on Jul 21 2022

Rey Luar Jr.

0 Answers Avg Quality 2/10

flask connect to mssql

Contents

More Related Answers

flask connect to mssql

Closely Related Answers

flask connect to mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.