Am 31.01.2011 15:55, schrieb RENIER Mélanie:
Dear All,
I have one problem when trying to import data via odbc.
It connect to the server but does not achieve to load the data.
I have the following message error:
? open dsn=inf1 --odbc
Connected to ODBC data source 'inf1'
? data x y query="select code,denomination from usig.co_etciv" --odbc
Error executing script: halting
> data x y query="select code,denomination from usig.co_etciv" --odbc
Do you maybe know where does the problem come from or where I can have
more details?
Thanks in advance,
Kind Regards,
Mélanie Renier
Hi Mélanie,
sounds for me like an error resulting from a misspecified SQL statement.
Is it an Access Database? Or perhaps the stucture of your workfile does
not fit.
By the way, I personally prefer performing ODBC operations with scripts,
because it much easier to alter the code and to reuse it.
In terms of importing data via ODBC I've got another general question
myself:
obs-format combinded with string (%s) does not work, or to be
precise, GRETL
crashes immediately! Could someone provide an example for such
string indices?
E.g. I want to load for 4 Countries GER, UK, JP, CN the CPI and WPI
series in the
following order: GER CPI
GER WPI
UK CPI
.....
I succeeded in using numbers instead of Names (1:1; 1:2; 2:1...).
But if it's possible to
use the strings with %s it would be even nicer.
Thanks in advance
Pindar