Jun-26-2018, 04:44 PM
(This post was last modified: Jun-26-2018, 04:44 PM by Maverick494.)
I personally use something like the following:
https://docs.microsoft.com/en-us/sql/con...erver-2017
import pymysql conn = pymysql.connect(host=dbhost, port=3306,user=username,password=dbpassword,db='database',autocommit=True,local_infile=1) cursor = conn.cursor() cursor.execute(Query) conn.close()You should be able to do something similar with MSSQL using a DSN
conn = pyodbc.connect(r'DSN=mynewdsn;UID=user;PWD=password')yea; here is a good example
https://docs.microsoft.com/en-us/sql/con...erver-2017