On Fri, 20 Mar 2020, Artur Tarassow wrote:
I had again a look at this issue. So the connection is there and the
correct
data gets fetched. However, the resulting series "klima" has only zeros. The
error message is "Error executing script: halting". The terminal output is:
<Terminal>
SQL query: 'SELECT KLIMA FROM OV_AS_LAB_LUMEN.IFO_DATA LIMIT 5'
Number of columns = 1
col 1 (KLIMA): data_type SQL_DECIMAL, size 4, digits 1, nullable 2
Number of Rows (from SQLRowCount) = 5
Fetch, row 0: col 0: data value 102.2
Fetch, row 1: col 0: data value 102.5
Fetch, row 2: col 0: data value 99.7
Fetch, row 3: col 0: data value 102.6
Fetch, row 4: col 0: data value 101.5
SQLFreeHandle(SQL_HANDLE_STMT): SQL_SUCCESS
SQLDisconnect: SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_DBC): SQL_SUCCESS
SQLFreeHandle(SQL_HANDLE_ENV): SQL_SUCCESS
</Terminal>
I know that it worked before latest feature implementing fetching
string-valued series.
I'm not able to replicate the proble (yet).
To make debugging of ODBC a bit easier I've added an ODBC-specific
--verbose option to the "data" command. Use that option and you'll
get debugging spew in the regular gretl output (not stderr any
more). I've also added a little more detail.
I'm attaching a little tar.gz file with kit to try out my attempted
replication of the problem. (For me the example works OK.) There's a
README in the package, but here's the gist: create a tiny database
that mimics the data Artur showed, then read from it using gretl.
Allin