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) > > ______________________________________________ > [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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 ______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
