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