[R] RODBC on linux

Omar Lakkis abu3ammar at gmail.com
Wed Dec 8 16:38:43 CET 2004


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)




More information about the R-help mailing list