Re: [Gretl-users] import data via odbc

Dear All, I found that in fact if GRETL says it connect to the data source inf1 in Oracle, it does not stay connected to it! Does somebody already encounter this problem? Thanks in advance, Kind Regards, Mélanie Renier Attaché Etudes Financières et Actuarielles Tél. 02 529 33 34 melanie.renier(a)onprvp.fgov.be Office national des Pensions Tour du Midi ~ 13e étage 1060 Bruxelles [cid:image001.gif@01CBC2B4.CBCE2E20] _______________________________________________ Pensez à l'environnement avant d'imprimer ce message! De : gretl-users-bounces(a)lists.wfu.edu [mailto:gretl-users-bounces@lists.wfu.edu] De la part de Leon Unger Envoyé : lundi 31 janvier 2011 17:04 À : Gretl list Objet : Re: [Gretl-users] import data via odbc 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 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