[R-sig-DB] Problem Connecting to Oracle with R from Windows XP

[Song, Alex]

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]]