When connected to Postgres, using the PostgreSQL ANSI(x64) Driver for PostgreSQL 12, PostgresSQL ODBC Driver 9.05 and Toad Data Point (TDP) 4.3.0.718 (64 bit), and right-clicking on a table in the Object Explorer:
-
- Selecting " View Details ", and looking at the " Columns " tab, it's empty, the info about the columns is missing, no error messages.
-
- Selecting " Generate SQL | Select Statement | To Editor ", it shows:
-- Toad Data Point can't find columns. The object may be invalid or a type that is not supported.
Looks like the same issue as 232520 on support.quest.com, but I don't have permission to view the solution.
The above scenario works with Oracle and MySql.
Thanks!
Copied the KB article from our Support site below... although it involves ODBC for another platform (Cloudera Impala) hoping that the work-around might work in your case with Postgres...
Title
Empty columns tab in the Table-Details when connected to Cloudera Impala
Description
When connected to Cloudera Impala, using the Cloudera ODBC Driver for Impala version 2.5.36.1009 64-bit and Toad Data Point (TDP) 4.2.1.303 (64 bit), and right-clicking on a table in the Object Explorer:
-
- Selecting " View Details ", and looking at the " Columns " tab, it's empty, the info about the columns is missing, no error messages.
-
- Selecting " Generate SQL | Select Statement | To Editor ", it shows:
-- Toad Data Point can't find columns. The object may be invalid or a type that is not supported.
Resolution
WORKAROUND 1:
Right-click on the table in the Object Explorer, and click on " Refresh All ", and try again.
WORKAROUND 2:
Try installing the Cloudera ODBC Driver for Impala version 2.5.39.1020 64-bit, and once the connection is using it, again, right-click on the table in the Object Explorer, and click on " Refresh All ", and try again.