Recent

« previous next »
Pages: [1]

Author Topic: How to get table names with ODBC  (Read 3087 times)

bigeno

  • Sr. Member
  • ****
  • Posts: 266
How to get table names with ODBC
« on: May 11, 2014, 12:53:42 pm »
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 ?
Logged

LacaK

  • Hero Member
  • *****
  • Posts: 691
Re: How to get table names with ODBC
« Reply #1 on: May 13, 2014, 12:50:22 pm »
I am afraid, that Excel ODBC driver does not implement ODBC API function SQLTables as indicated by error message "optional function not implemented"
Logged

bigeno

  • Sr. Member
  • ****
  • Posts: 266
Re: How to get table names with ODBC
« Reply #2 on: May 13, 2014, 02:24:12 pm »
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 ?
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018