Here is what I am trying to do - -
I have an ODBC connection setup on some computers with a manual password entered. The password changed recently and the connection should not be working but I see no difference in the performance of the program.
I would like to test the ODBC connection in its current state without entering the correct username and password. I know it should fail and if I enter the old password in the ODBC connection settings and then test the connection it does fail. But I would like to just prove the current connection state is invalid without changing anything.
Everything I find points to me entering the username and password to test the connection. I figured I would ask the community to see if their is any way I can do it without manually entering the data and just using the currently stored settings.