[R-sig-DB] Resolved: RODBC query returns no results
Daniel Ricard
r|c@rdd @end|ng |rom m@th@t@t@d@|@c@
Thu Jun 22 00:08:35 CEST 2006
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
More information about the R-sig-DB
mailing list