[R-sig-DB] Resolved: RODBC query returns no results

[Daniel Ricard]

Jérôme,
Adding the "believeNRows=FALSE" to odbcConnect solved my problem too.


chan <- odbcConnect(dsn="gfsDB", uid = "postgres", case='postgresql', 
believeNRows=FALSE)


Thanks, this is awesome.

Re: RDBI, the developers are likely on this mailing list and may wish to 
comment on the status of the package. From what I gather, RODBC is probably a 
better option to connect to postgresql. The DBI website says "under 
construction" from 5 years ago:
http://developer.r-project.org/db/

and this site:
http://stat.bell-labs.com/RS-DBI/index.html

points to the following link for postgresql support: 
http://sourceforge.net/projects/rdbi

However, the package is no longer under active development. So RODBC seems 
like the most viable alternative.
Cheers,

Dan


Le Mercredi 21 Juin 2006 18:12, jerome prudent a écrit :
> Hey!
> I solved my problem specifying password and believeNRows=FALSE in
> odbcConnect:
> channel <- odbcConnect("sc", uid="admin", pwd="pass", case="tolower",
> believeNRows=FALSE)
>

Le Mercredi 21 Juin 2006 17:56, jerome prudent a écrit :
> Hi!
> I've seen you have problem with RODBC and I'm exactly in the same
> unconfortable position: queries have no results.
>
>
> Has you can see, we have exactly the same config and the same problem. Do
> you think it's an ubuntu specific problem?
>
> Did you already solved your problem? How?
> Have you tried the RDBI package?
> Thanks!!
> Jérôme Prudent