Toad World® Forums

Queries seem to execute after DB connection has been lost.


Working remotely I have to VPN into my corporate network and then connect to Oracle 9i DB via TNSNames. This morning, while using TDA v3.0.0.688 Beta I neglected to VPN back in and reconnect to the database.

I issued several queries in Editor and the Messages window indicated that they had executed successfully, but no Result Sets were generated. Only after much frustration did I realize that the Oracle connection didn’t have the “connected” symbol. [Right-click --> Reconnect] solved the problem but only after much confusion.

I am accustomed to Toad for Oracle’s functionality where the DB Connection is simply reestablished when a query is attempted. How is TDA designed to handle this?

–Nate Hamilton