Change pyodbc connection from using args to using string

microsoft / sqlmlutils

Utility functions for easier usage of SQL Server Machine Learning Services

Other

32 stars 33 forks source link

Change pyodbc connection from using args to using string #67

Closed JonathanZhu11 closed 4 years ago

JonathanZhu11 commented 4 years ago

pyodbc connection originally used args for connection.

With SQL Server driver, empty uid and pwd worked as Trusted_Connection, but with ODBC Driver 17 empty uid and pwd is just empty and fails. There is an arg trusted_connection instead.

By using a string, we circumvent this issue.