[R-sig-DB] RODBC query returns no results
Daniel Ricard
r|c@rdd @end|ng |rom m@th@t@t@d@|@c@
Mon Jun 19 20:36:56 CEST 2006
Hello,
I'm using RODBC to connect to a database but somehow the queries return no
results. postgresql tells me that there are 963 entries in the table:
gfsDB=# select count(*) from estimates;
count
-------
963
(1 row)
but the query in R only returns the column names, not the anticipated data:
> chan <- odbcConnect(dsn="gfsDB", uid="postgres")
> qu <- paste("select * from estimates")
> sqlQuery(chan, qu, errors= TRUE)
[1] specname tsn institution region closedarea modelno
[7] parameter level1 df estimate stderr lowerwaldcl
[13] upperwaldcl chisq probchisq
<0 rows> (or 0-length row.names)
> odbcGetInfo(chan)
DBMS_Name "PostgreSQL"
DBMS_Ver "08.01.0102 PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC
gcc (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)"
Driver_ODBC_Ver "03.00"
Data_Source_Name "gfsDB"
Driver_Name "libpsqlodbc.so"
Driver_Ver "08.01.0102"
ODBC_Ver "03.52"
Server_Name "localhost"
I would like to know how to further troubleshoot this, I'm kind of stuck right
now. The same query returns the appropriate data when issued through Perl DBI
or SAS/CONNECT.
Cheers,
Dan
More information about the R-sig-DB
mailing list