how do I successfully use PDO with my ODBC for MSSQL?

[Maverick494]

I personally use something like the following:

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