Skip to content
Prev 367 / 1559 Next
Original Raw

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:
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 at nrcan.gc.ca <mailto:Alex.Song at nrcan.gc.ca>

Thread (2 messages)

Song, Alex Problem Connecting to Oracle with R from Windows XP Aug 15 Seth Falcon Problem Connecting to Oracle with R from Windows XP Aug 15