ODBC connection successfull but failed to load tables.
Am able to connect to ODBC database, but all tables in db are not reflecting in databasetables column. Connection to odbc is tested successfully. Can anyone help me how to retrieve the entire list of tables from database.
Try the SQLTABLES function. See this discussion for an example: Re: How to load all tables in a database in oracle?. The SQLTABLES function can be used on any odbc source. It's not limited to oracle databases or excel files.
