How to enable or disable the Auto-Connect to a specified database feature? How to stop Toad from auto-connecting to my schema?
RESOLUTION 1:
1. In the Toad connection login screen, find the connection information in the grid.
2. Under the "Auto Connect" column, check / uncheck the box.
3. Click Connect or Close button to close the login screen, which will also save the changes you made.
NOTE:
If the Auto Connect column is not showing or if it's hidden, right-click the columns area and choose "Select Visible Columns". Ensure that the box for Auto Connect is check marked. This will display the Auto Connect column and you should now be able to check/uncheck boxes under it.
RESOLUTION 2:
1. Close Toad.
2. Look in your Toad for Oracle\User Files folder and find the "Connections.ini" file.
3. Open the file and find the database that is auto connecting when launching Toad.
4. Once you find the database, locate "AUTOCONNECT" under this database and change it from equaling 1 to equaling 0 to disable or visa verse to enable.
5. Save and close the file.