Why can't I change the client selected for connection? How do you disconnect a connection in SQL Optimizer?
I would like to change my client selection for connection the SQL Optimizer's connection window, but it is grayed out. I see there are still existing connections between Optimizer and some of my databases from previous tuning jobs. But those jobs have finished and the windows closed (no Tuning Lab tabs or Batch session opened on screen). How do I disconnect these?
You cannot change the client while there is still a live connection between the application and the database.
The product will make its connection to database whenever the connection is needed (per Tuning Lab session, Batch Optimizer session, etc). You will be prompted to connect when you open a window/session in Optimizer. Or if you send in a query from Toad or another calling application, it will connect automatically. The product will try to retain the unused connections for the next action.
There are currently no disconnect options in SQL Optimizer.
The only way to clear all connections is to exit the product completely (not just tabs/sessions).
When you launch SQL Optimizer again, try to connect and the client selection field should be enabled since no connection have been made. Keep in mind if you launch Optimizer from the editor window with a query in Toad, it may carry over the connection info you use in Toad to connect. In this case the connect is made automatically and may lock the client selection field.
