R help - Aug 2007 - Problem Connecting to Oracle with R from Windows XP

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

 


	[[alternative HTML version deleted]]

You also need the ROracle package.

On 8/15/07, Song, Alex <asong@pfc.cfs.nrcan.gc.ca>
wrote:
>
> 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@nrcan.gc.ca <mailto:Alex.Song@nrcan.gc.ca>
>
>
>
>
>         [[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.
>
>
	[[alternative HTML version deleted]]