I know how to use MySQL, but now I'm fighting with MSSQL. I want to connect via ODBC, but it always fails. I have the corresponding connection with Python which is
Code: Select all
con = pymssql.connect(host='sqlsrv01', user='username', password='password', database='databasename', as_dict=True)
I tried
Code: Select all
OpenDatabase(#PB_Any,"host=sqlsrv01 dbname=databasename","username","password",#PB_Database_ODBC)
Code: Select all
OpenDatabase(#PB_Any,"sqlsrv01","username","databasename",#PB_Database_ODBC)