[Gretl-devel] Re: Problem with ODBC query

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.