Return
-
Title
Netezza - Can't use query builder -
Description
When connected to Netezza, and trying to drag a Table into the Query Builder, Toad hangs, the table is never shown in the query builder, Toad becomes unusable and one has to kill it from the Task Manager. -
Cause
The "Database" in the TDP connection, and, the "Database" in the DSN definition are different.
-
Resolution
Make sure there isn't a mismatch between TDP's "Database" entry and DSN's "Database" entry.Also, entering only a value for the database entry, like shown below "System", and leaving the schema blanked, one may use any database in the TDP's "Database" entry.