Re: [R] using DBI

From: chao gai <chaogai_at_duineveld.demon.nl>
Date: Wed 10 Jan 2007 - 19:34:00 GMT

The way MySQL works, I use RMySQL to contact, which in turn uses DBI. There is a library ROracle which, from the manual, works the same. Hence I would start by looking at Roracle for the connection and proceed from there.

Kees

On Wednesday 10 January 2007 19:39, Bond, Stephen wrote:
> can anybody provide a reference to a document on using DBI and what is
> needed to make it work?
>
> I try: drv=dbDriver("Oracle")
>
> and it complains about not finding a function.
> The DBI.pdf does not require anything else installed, but looking at the
> archive I discovered there is more stuff to be installed.
> This is on Solaris 5.10 with a full Oracle install, so all Oracle libs
> are available and sqlplus works.
> I am trying to connect remotely to another Oracle instance.
>
> Thank you very much
> Stephen
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html and provide commented, minimal,
> self-contained, reproducible code.



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Thu Jan 11 06:39:11 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Wed 10 Jan 2007 - 20:30:29 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.