Re: [Gretl-users] ODBC troubles
On Wed, 3 Feb 2010, Chris wrote:
Thanks for the help Allin,
That was just my own lack of understanding of how to use that command. So
now, thanks to your help, I have it working. The ODBC command executes and
it pulls 217 observations, which is the same number I would expect from
running the sql query in query analyzer. However, now that it's in gretl,
when I try to view the dat I get an "maxbufftemp: no valid values" error,
however, when I look at the data in query analyzer It's there (example piece
of data from query analyzer: 39.900"
I think the problem is that you're using
obs-format="%d"
which is designed for integer data, but with values like 39.900
you actually have floating-point data. Try dropping the format
string:
data maxbufftemp @QRY1 --odbc
Allin Cottrell