How can I make my OdbcConnect use Windows Integrated Security authentication?
You can connect to the database being tested using Windows Integrated Security by adding an additional parameter to the OdbcConnect function. A normal connection using SQL authentication would look similar to:
To allow you to connect using Windows Integrated Security you need to modifiy the OdbcConnect and add "Trusted_Connection=yes". The connection to the database will now look similar to: