I’m trying to create a utility in VB.net to connect to a SQL Server database, run several queries, and display the results in text boxes.
The main form has login text boxes for Server name, database, user, and password. It also has a button to disconnect from the database after the information has been gathered.
I want to be able to reset the connection information so I can re-enter the login using different parameters and connect to a different server or database.
The app seems to store the connection information so it continues to connect to the first database even though I have changed the login settings and logged back in.
Is there a way to reset the connection information without having to close the app and restart it?