dialect requires username password, which breaks using trusted credentials

[patter001]

the create_connect_args requires username password in the connect string instead of allowing for trusted credentials. It should default to None for username and password if they are not in the connect string

[sandan]

@patter001 Could you elaborate more on "allowing for trusted credentials"?

[patter001]

if the username/password are "None" then on windows, the next layer of code (its been a while I forget which piece) sees the None and instead attempts to use windows credentials. This allows for our higher level tools to query without having to prompt user for credentials or save in to the code.

[sandan]

By next layer of code do you mean the OdbcConnection? All it will do is pass it to the ODBC layer.

The username and password can be saved elsewhere and read into the code (environment variables, text files, etc.)