[R] RODBC on linux

[Brian D Ripley]

If you look in the RODBC help pages for odbcConnect you will see this
mentioned with respect to Oracle and Sybase.  Try the fix mentioned there.

On Wed, 8 Dec 2004, Omar Lakkis wrote:

> I am using RODBC 1.1-2 with R 2.0.0 on a Debian box with a singel
> Pentium processor. My database is Informix 7.32.
> When  I run a sql query I get the table header back but no data is
> selected. Please note this example:
>
> Table "t1" has two columns, "a" and "b".  The table is populated with
> three rows.
>
> Thi si the definition of the table:
> Column name          Type                                    Nulls
> a                                 smallint                                yes
> b                                 integer                                 yes
>
>
> > sqlQuery(pricedb, "select * from t1")
> [1] a b
> <0 rows> (or 0-length row.names)
> > class(a$a)
> [1] "integer"
> > class(a$b)
> [1] "integer"
>
> using my C code on the same box, utalizing teh same odbc installation I get:
> 1    2
> 3    4
> 5    6
>
> Does anyone have an idea why I get the table header but no data?
>
> Also, sqlTables() return no rows.
>
> > sqlTables(pricedb)
> [1] TABLE_QUALIFIER TABLE_OWNER     TABLE_NAME      TABLE_TYPE
> [5] REMARKS
> <0 rows> (or 0-length row.names)
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595