I’m running TDP 18.104.22.1686 Base Edition. I have been encountering an issue when I connect to an IBM iSeries database for a long time and is now starting to happen with more frequency, almost every time I connect.
The connection to the database is done using IBM’s iSeries Access ODBC driver version 13.64.05.00, CWBODBC.DLL from 11/05/2011.
The issue I am running into is, that once I am connected to the database, pressing Fkeys to run my query from the editor does nothing. I then will select, the UI button, Execute SQL or Execute from Cursor. The button will remain pressed even though I released the mouse down action and TDP proceeds to get caught cycling somewhere. The cursor goes to wait/busy mode and the only way I can resolve the issue to allow me to do anything in TDP is to force quit.
I can sometimes, execute my query once, then if I change something in the SQl statment and try to execute again, it will then go back to this “frozen” state.
Any suggestions on what the root cause is for this and how I might go about resolving? This issue only happens when I am connected to the iSeriece database. Never with Oracle, Microsoft SQL Server or IBM DB2.