I'm trying to get a list of table names from the ODBC Generic host using a DSN connection. (elastic ODBC connection)
I have tried this earlier using the information schema query on SQL with different hosts. But one particular host doesn't have an information schema.
1- I need an SQL query on this DSN ( Odbc Generic host) that allows me to get the table names
or
2- any other method that gets tables and later uses some other tool to get the table names.
(I've attached a picture of the connection as well as the error when I tried using the information schema query -but hiding the content)
I would try contacting the IT team responsible for maintaining this database server to see what is the correct configuration under the ODBC manager area in Windows.