How to get table names with ODBC
lazarus / 16-Databases

----------------------------------------------------------------------
bigeno · 2014-05-11 10:53

I try to get sheet names from excel db using ODBC but I get error:
SQLState: HYC00 Native error: 106 optional function not implemented
I use TODBCConnection.GetTableNames for this. With MS Access is ok,
but I want to get Excel sheet names ;( how to do that ?

----------------------------------------------------------------------
LacaK · 2014-05-13 10:50

I am afraid, that Excel ODBC driver does not implement ODBC API
function SQLTables as indicated by error message "optional function
not implemented"

----------------------------------------------------------------------
bigeno · 2014-05-13 12:24

in fact, each function returns me same error.
If I skip GetTableNames and and use sql with sheet name (select * from
Sheet1, and other [Sheet1$], Sheet1$) then also error "... not
implemented).
Only GetConnectionInfo works.
I wonder if someone at all get data from excel using ODBC ?