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

[cyberion1985]

oops, sorry !

Then python! The above screenshots should still be valid. I actually started with python and then moved to PHP. The below basic code should just simply see if it can make a connection. So, THANK YOU as I was able to use python to get it working !!! And who knows, this might help in fixing the PHP too !

import pyodbc

con = ""

try:
    con = pyodbc.connect(
        r'DRIVER={ODBC Driver 11 for SQL Server};'
        r'SERVER=SERVER\SRVINSTANCE;'
        r'DATABASE=dbname;'
        r'UID=username;'
        r'PWD=password;'
        )
except pyodbc.Error, err:
    print err

if con:
       
    cur = con.cursor()
    
    con.close()
    
    print "yes! it works!"