Skip to content
Prev 196 / 1559 Next

RODBC query returns no results

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:
[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)
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