[Libreoffice-bugs] [Bug 111862] ElevateDB dbISAM ODBC: error "Cannot find column names" when doing a query using the wizard

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=111862

--- Comment #15 from Lionel Elie Mamane <lionel at mamane.lu> ---
LibreOffice 5"  1420-d78        ENTER SQLColumnsW 

here LibreOffice, calls the ODBC SQLColumns() column with parameters:
 Catalog = "C:\" (without quotes)
 Schema = none (empty / null)
 Table = "Program Files (x86)\High Meadow Business Solutions\RetailEdge
8.2\Server\Data\Customer\" (without quotes and without the newlines introduced
by bugzilla formatting)

Is this correct? Is this a valid (catalog, schema, table) triple for a valid
table of a valid database?
If not, we have to go up in the log and understand where this is coming from.

If yes, we continue:

LibreOffice 5"  1420-d78        EXIT  SQLNumResultCols  with return code 0
(SQL_SUCCESS)
                HSTMT               0x000000ADF02FDE60
                SWORD *             0x000000ADE89EA9D0 (18)

which means the result returned by SQLColumns (that is, a result set that
describes the columns of the table, each column of the table being one row in
that result set) has 18 columns. This is correct and to be expected.

Then:

LibreOffice 5"  1420-d78        EXIT  SQLFetch  with return code 100
(SQL_NO_DATA_FOUND)
                HSTMT               0x000000ADF02FDE60

Here we have it: the ODBC driver is telling us it is not giving us any data on
the columns of the table. Which is what LibreOffice is complaining about. No
information on the columns of the table. No row in the result set returned by
SQLColumns()

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170817/2f0af07c/attachment.html>