[CR #575450] If you are using Adaptive Server Enterprise as thesource database and ODBC as the interface for connectivity, not all the tables created in the database are always returned. This issue is related to the user role. If you create tables without the sa_role, but later grant it, tables that were created before the sa_role was granted do not appear when you request for the list of tables.
Workaround:
Grant access to the users for all tables. Use the ODBC interface to request the tables.
Alternatively, specify the interface as Sybase and request the list of tables. After selecting the tables you need, change the interface back to ODBC.
