[Gretl-devel] Re: Problem with ODBC query

At least with latest git version on Ubuntu 18.10, I am experiencing problems with ODBC. Both of the following queries are pretty standard, and I've succesfully used the first one before. Stuff also works fine using the isql client via the terminal. <QUERY_1> open dsn=@DSN user=@USER password=@PW --odbc data klima query="SELECT KLIMA FROM OV_AS_LAB_LUMEN.IFO_DATA" --odbc </QUERY_1> <ERROR_1> ERROR: Error executing script: halting > data klima query="SELECT KLIMA FROM OV_AS_LAB_LUMEN.IFO_DATA" --odbc </ERROR_1> The weird thing is that I obtain a new series but which has only zero values which is wrong. <TERMINAL_1> SQLDisconnect(dbc): SQL_SUCCESS SQLFreeHandle(SQL_HANDLE_DBC, dbc): SQL_SUCCESS SQLFreeHandle(SQL_HANDLE_ENV, OD_env): SQL_SUCCESS SQL query: 'SELECT KLIMA FROM OV_AS_LAB_LUMEN.IFO_DATA' Number of columns = 1 col 1 (KLIMA): data_type SQL_DECIMAL, size 4, digits 1, nullable 2 Number of Rows (from SQLRowCount) = 1886 SQLFreeHandle(SQL_HANDLE_STMT): SQL_SUCCESS SQLDisconnect: SQL_SUCCESS SQLFreeHandle(SQL_HANDLE_DBC): SQL_SUCCESS SQLFreeHandle(SQL_HANDLE_ENV): SQL_SUCCESS </TERMINAL_1> Here "sektor" is a string variable. <QUERY_2> open dsn=@DSN user=@USER password=@PW --odbc data sektor query="SELECT SEKTOR FROM OV_AS_LAB_LUMEN.IFO_DATA" --odbc </QUERY_2> <ERROR_2> ERROR: Error executing script: halting > data sektor query="SELECT KLIMA FROM OV_AS_LAB_LUMEN.IFO_DATA" --odbc </ERROR_2> Again I get a new series but all values are missings which is also wrong. <TERMINAL_2> SQLDisconnect(dbc): SQL_SUCCESS SQLFreeHandle(SQL_HANDLE_DBC, dbc): SQL_SUCCESS SQLFreeHandle(SQL_HANDLE_ENV, OD_env): SQL_SUCCESS SQL query: 'SELECT SEKTOR FROM OV_AS_LAB_LUMEN.IFO_DATA' Number of columns = 1 col 1 (SEKTOR): data_type SQL_VARCHAR, size 20, digits 0, nullable 2 binding data col 1 to strvals[0] (len = 20) Number of Rows (from SQLRowCount) = 1886 SQLFreeHandle(SQL_HANDLE_STMT): SQL_SUCCESS SQLDisconnect: SQL_SUCCESS SQLFreeHandle(SQL_HANDLE_DBC): SQL_SUCCESS SQLFreeHandle(SQL_HANDLE_ENV): SQL_SUCCESS </TERMINAL_2> Any idea what's going on here?