[R-sig-DB] Problem Connecting to Oracle with R from Windows XP
Song, Alex
@@ong @end|ng |rom p|c@c|@@nrc@n@gc@c@
Wed Aug 15 23:26:38 CEST 2007
Hello,
I installed RGui 2.5.1 and package DBI on Windows XP and tried to connect to Oracle database which is on a Linux server. When I tried to use dbDriver("Oracle"), I got an error as follows:
> drv <- dbDriver("Oracle")
Error in do.call(as.character(drvName), list(...)) :
could not find function "Oracle"
>
Could anyone tell me how to connect to Oracle with R from Windows XP? Do I need to configure any environment variables? Do I need to configure ODBC? Do I need to install any other packages? I have Oracle client 10g installed on my computer and I can connect to the Oracle database using other client software like Toad, SQLPlus, or SQL Developer.
Thank you very much.
Alex
Alex Song
Data Management Specialist / Sp�cialiste en gestion des donn�es
National Forest Inventory / Inventaire forestier national
Pacific Forestry Centre / Centre de foresterie du Pacifique
Canadian Forest Service / Service canadien des for�ts
Natural Resources Canada / Ressources naturelles Canada
Government of Canada / Gouvernement du Canada
506 West Burnside Road / 506 chemin Burnside ouest
Victoria, BC V8Z 1M5
Phone (250) 363-3342
Facs: (250) 363-0775
Email: Alex.Song using nrcan.gc.ca <mailto:Alex.Song using nrcan.gc.ca>
[[alternative HTML version deleted]]
More information about the R-sig-DB
mailing list