Re: [Gretl-users] import data via odbc

[Leon Unger]

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

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