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

[David James]

Daniel Ricard wrote:
> 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

Yes, you're right, it should point to the bioconductor site.

> 
> 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
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db

-- 
David A. James
Statistics Research, Room 2C-276            Phone:  (908) 582-3082       
Bell Labs, Lucent Technologies              Fax:    (908) 582-3340
Murray Hill, NJ 07974-0636