<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - ElevateDB dbISAM ODBC: error "Cannot find column names" when doing a query using the wizard"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111862#c15">Comment # 15</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - ElevateDB dbISAM ODBC: error "Cannot find column names" when doing a query using the wizard"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111862">bug 111862</a>
from <span class="vcard"><a class="email" href="mailto:lionel@mamane.lu" title="Lionel Elie Mamane <lionel@mamane.lu>"> <span class="fn">Lionel Elie Mamane</span></a>
</span></b>
<pre>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()</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>