Hello,
After upgrading from Toad Data Point 6.0 to 6.3, I am now facing an issue in the SQL editor when making direct connections to DBs with the native DB user account.
Let's say my NetezzaSQL systemDSN for production is VISUAL_DB for the database field; In Toad 6.0, I would be able to make an IBM Netezza connection in Toad to STG_SMPL_DB using STG_SMPL_DB_USR. Once I opened the SQL editor for that connection, the selected DB at the top would state STG_SMPL_DB...and when I ran any code at all, it would remain the same.
Now, in 6.3 I make the same connection, with the same systemDSN for production, still defined as VISUAL_DB; When I run any code under the connection STG_SMPL_DB using STG_SMPL_DB_USR it will revert the selected DB in the editor to "VISUAL_DB" as defined in the systemDSN.
Is there any way to keep the selected DB from reverting to the DSN defined one in 6.3, or will I need to make multiple systemDSN's to define every single DB connection to avoid that?