Not sure if anyone else has seen this behavior before or not, but it’s getting to the point where TDA isn’t a viable option for my department.
Basically, what happens is if we start executing a query, then figure out that, whoops, we forgot something, and try to cancel the query, one of two things will happen:
TDA will lock up completely, and we must force close from Task Manager.
TDA will cancel the query, but we get a dialog box that says “Connection to database lost and successfully reopened. Do you wish to execute the last command again?” - no matter which option we chose - Yes or No - the dialog box will not go away, and we must still force close TDA from the Task Manager.
We’ve been seeing this behavior since 2.1 and hoped it would go away in later releases; however as more and more people come online to using TDA, the issue is becoming more severe.
Any ideas or thoughts would be great. Please bear in mind that we do NOT have DBA access to the Oracle instance, so if it’s a config issue on that side, we’re hosed; but I don’t think it is as other tools (ie. SQL Tools) will cancel queries just fine without any problems.