using DBI
Yes I have that and
drv=dbDriver("Oracle") executes without complaint.
The platform is Solaris 10 on x86. I try
conn=dbConnect(drv,user='user',password='password',dbname='dwsh.blabla.com')
which fails complaining about no listener.
the connect string that does the job using occi is:
const string
connectString="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=
mplstcp)(PROTOCOL=TCP)(Host=dwsh.blabla.com)(Port=1522)))(CONNECT_DATA=(SID=dwsh)))";
Could you pls suggest the syntax to call dbConnect?
Thank you greatly
Stephen C. Bond
Queen's University
On Thu, 11 Jan 2007, Don MacQueen wrote:
First: Have you successfully installed the ROracle package? (Until you've done that, I don't think there's any point in trying to help with or answer the other questions.) At some point you will have to tell people what platform you're running R on (see http://www.R-project.org/posting-guide.html), and you may get asked to provide commented, minimal, self-contained, reproducible code. -Don At 9:21 PM -0600 1/9/07, Stephen Bond wrote:
Dear DBI Maintainer, Please, help with the following connection: I need to connect to an oracle database on HP Unix host. I looked at the DBI.pdf which I am sure is very informative for the competent readers but it is French to me. I am not sure what is the difference between Oracle and ROracle drivers and how to provide an IP address if that is at all possible. Also, is there a need for special libs on the host as the DBI.pdf says that the drivers need to be extended on the backend? I know how to use SQL and conect from SAS or C++ using occi, but the R DBI is a challenge. Thank you very much Stephen
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db
-- -------------------------------------- Don MacQueen Environmental Protection Department Lawrence Livermore National Laboratory Livermore, CA, USA --------------------------------------