(according to Gretl User's Guide) have a couple of commands being executed automatically (loading the dataset into an R-dataframe). Nothing of the sort happens.

Is it a problem with R or gretl (both the latest version of gretl and R otherwise runs perfectly) ?

Lars

>>> <gretl-users-request@lists.wfu.edu> 10-02-04 18:07 >>>
Send Gretl-users mailing list submissions to
    gretl-users@lists.wfu.edu

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.wfu.edu/mailman/listinfo/gretl-users
or, via email, send a message with subject or body 'help' to
    gretl-users-request@lists.wfu.edu

You can reach the person managing the list at
    gretl-users-owner@lists.wfu.edu

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Gretl-users digest..."


Today's Topics:

1. Re: ODBC troubles (Allin Cottrell)
2. Re: ODBC troubles (Chris)
3. Re: ODBC troubles (Allin Cottrell)
4. Re: ODBC troubles (Chris)
5. Re: ODBC troubles (Allin Cottrell)


----------------------------------------------------------------------

Message: 1
Date: Wed, 3 Feb 2010 17:20:35 -0500 (EST)
From: Allin Cottrell <cottrell@wfu.edu>
Subject: Re: [Gretl-users] ODBC troubles
To: Gretl list <gretl-users@lists.wfu.edu>
Message-ID: <Pine.A41.4.58.1002031703430.2568554@f1n11.sp2net.wfu.edu>
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Wed, 3 Feb 2010, Chris wrote:

> It should be an integer string that is the date without the / in
> them so feb 1 , 2007 stored as 20070201. In the case where I
> can import data into gretl I'm not even selecting that column
> though.
>
> The particular bit of data I'm pulling is stored as numeric(7,3)
> in an mssql server 2008. I believe we can read that as numeric
> precision 7, numeric scale 3
> For the small and simple test query I was using the data is stored as
> numeric(16,3) in the same sql server.

Thanks for persevering! We're making some progress -- you've
given me some ideas for making the manual more explicit. As to the
specifics:

First, on the "obs-format" business: the point of that is if you
want to screen the values coming in via ODBC and add only some of
them to the dataset. But if your identifiers look like "20070201"
and you use "%d" to grab the whole integer value, then _all_ the
ODBC values will be screened out (leaving nothing but missing
values or NAs in the input series). That's because a string like
"20070201" will not match any gretl observation identifier. Note
that the gretl obs identifiers are what you see in the leftmost
column if you do "print index --byobs" after doing "nulldata" and
"setobs".

So in this case it looks as if you want a straight one-column
import. And I need to research "numeric(7,3)" in mssql and see
what I can find. My first thought is that since gretl is asking
for SQL_C_DOUBLE, it's the server's fault that it's _not_ giving
gretl the values in the C double-precision format. But I'm not an
SQL expert and maybe it's not that simple.

Jack, any thoughts?

Allin Cottrell



------------------------------

Message: 2
Date: Wed, 3 Feb 2010 15:42:29 -0700
From: Chris <chris@quilley.net>
Subject: Re: [Gretl-users] ODBC troubles
To: Gretl list <gretl-users@lists.wfu.edu>
Message-ID:
    <93b3787f1002031442o6e0bae9ck1b47ea21c167c9ef@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Thanks,

That straightens out some things for me.
http://www.servers.net.in/Servers%20Archive-odbc%20sqlserver%20public%20microsoft/messages/147640_SQL-2008-SQLBindCol-SQL_C_DOUBLE-bug.html
I suspect that is the reason this isn't working. If you have any suggestions
on how to get around this I would appreciate it.

Thanks,

Chris

On Wed, Feb 3, 2010 at 3:20 PM, Allin Cottrell <cottrell@wfu.edu> wrote:

>
> On Wed, 3 Feb 2010, Chris wrote:
>
> > It should be an integer string that is the date without the / in
> > them so feb 1 , 2007 stored as 20070201. In the case where I
> > can import data into gretl I'm not even selecting that column
> > though.
> >
> > The particular bit of data I'm pulling is stored as numeric(7,3)
> > in an mssql server 2008. I believe we can read that as numeric
> > precision 7, numeric scale 3
> > For the small and simple test query I was using the data is stored as
> > numeric(16,3) in the same sql server.
>
> Thanks for persevering! We're making some progress -- you've
> given me some ideas for making the manual more explicit. As to the
> specifics:
>
> First, on the "obs-format" business: the point of that is if you
> want to screen the values coming in via ODBC and add only some of
> them to the dataset. But if your identifiers look like "20070201"
> and you use "%d" to grab the whole integer value, then _all_ the
> ODBC values will be screened out (leaving nothing but missing
> values or NAs in the input series). That's because a string like
> "20070201" will not match any gretl observation identifier. Note
> that the gretl obs identifiers are what you see in the leftmost
> column if you do "print index --byobs" after doing "nulldata" and
> "setobs".
>
> So in this case it looks as if you want a straight one-column
> import. And I need to research "numeric(7,3)" in mssql and see
> what I can find. My first thought is that since gretl is asking
> for SQL_C_DOUBLE, it's the server's fault that it's _not_ giving
> gretl the values in the C double-precision format. But I'm not an
> SQL expert and maybe it's not that simple.
>
> Jack, any thoughts?
>
> Allin Cottrell
>
> _______________________________________________
> Gretl-users mailing list
> Gretl-users@lists.wfu.edu
> http://lists.wfu.edu/mailman/listinfo/gretl-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wfu.edu/pipermail/gretl-users/attachments/20100203/02a446a1/attachment-0001.html

------------------------------

Message: 3
Date: Wed, 3 Feb 2010 17:51:49 -0500 (EST)
From: Allin Cottrell <cottrell@wfu.edu>
Subject: Re: [Gretl-users] ODBC troubles
To: Gretl list <gretl-users@lists.wfu.edu>
Message-ID: <Pine.A41.4.58.1002031748540.2568554@f1n11.sp2net.wfu.edu>
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Wed, 3 Feb 2010, Chris wrote:

> That straightens out some things for me.
> http://www.servers.net.in/Servers%20Archive-odbc%20sqlserver%20public%20microsoft/messages/147640_SQL-2008-SQLBindCol-SQL_C_DOUBLE-bug.html
> I suspect that is the reason this isn't working. If you have any suggestions
> on how to get around this I would appreciate it.

Ah, that reference is helpful. We'll see if we can find a way to
work around the bug in question. But I think that has to be in the
bowels of gretl's ODBC-import code; I don't think there's any way
to work around it at the level of user input.

Allin Cottrell


------------------------------

Message: 4
Date: Wed, 3 Feb 2010 15:58:32 -0700
From: Chris <chris@quilley.net>
Subject: Re: [Gretl-users] ODBC troubles
To: Gretl list <gretl-users@lists.wfu.edu>
Message-ID:
    <93b3787f1002031458o63140865mb4d7ab77877861ea@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

That's ok. It's about time for a Microsoft product to screw me over again; I
was just starting to think Microsoft products were decent and maybe I was
wrong to be a linux user at home for the last decade;)

If you guys can come up with anything to get me around this I would really
appreciate it. As a side note, do you know if anyone is working on updating
the import features to allow multiple variable imports?


Thanks,

Chris

On Wed, Feb 3, 2010 at 3:51 PM, Allin Cottrell <cottrell@wfu.edu> wrote:

>
> On Wed, 3 Feb 2010, Chris wrote:
>
> > That straightens out some things for me.
> >
> http://www.servers.net.in/Servers%20Archive-odbc%20sqlserver%20public%20microsoft/messages/147640_SQL-2008-SQLBindCol-SQL_C_DOUBLE-bug.html
> > I suspect that is the reason this isn't working. If you have any
> suggestions
> > on how to get around this I would appreciate it.
>
> Ah, that reference is helpful. We'll see if we can find a way to
> work around the bug in question. But I think that has to be in the
> bowels of gretl's ODBC-import code; I don't think there's any way
> to work around it at the level of user input.
>
> Allin Cottrell
> _______________________________________________
> Gretl-users mailing list
> Gretl-users@lists.wfu.edu
> http://lists.wfu.edu/mailman/listinfo/gretl-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wfu.edu/pipermail/gretl-users/attachments/20100203/09f57ac2/attachment-0001.html

------------------------------

Message: 5
Date: Wed, 3 Feb 2010 18:35:17 -0500 (EST)
From: Allin Cottrell <cottrell@wfu.edu>
Subject: Re: [Gretl-users] ODBC troubles
To: Gretl list <gretl-users@lists.wfu.edu>
Message-ID: <Pine.A41.4.58.1002031830380.2499032@f1n11.sp2net.wfu.edu>
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Wed, 3 Feb 2010, Chris wrote:

> That's ok. It's about time for a Microsoft product to screw me
> over again; I was just starting to think Microsoft products were
> decent and maybe I was wrong to be a linux user at home for the
> last decade;)

Well, I don't want to start a flamefest here, but I don't see how
one could possibly be wrong to use linux.

> If you guys can come up with anything to get me around this I
> would really appreciate it.

Try the new snapshot at

http://ricardo.ecn.wfu.edu/pub/gretl/gretl_install.exe

or on sourceforge.

> As a side note, do you know if anyone is working on updating the
> import features to allow multiple variable imports?

Nobody's working on that, that I know of. But it's not too hard
to replicate your query string with modification so as to grab as
many variables as you need.

Allin


------------------------------

_______________________________________________
Gretl-users mailing list
Gretl-users@lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users

End of Gretl-users Digest, Vol 37, Issue 7
******************************************