[R] RODBC - problems connecting to oracle through linux

From: Simon Collins <Simon.Collins-2_at_manchester.ac.uk>
Date: Fri, 28 Nov 2008 22:09:15 +0000


Hi

I'm presently trying to connect to Oracle through RODBC / UnixODBC on linux (Red Hat 5). I've successfully connected through the easysoft drivers but the trial license has run out and I'm trying to connect via the default Oracle 11G driver. However I'm getting the following error

> library(RODBC)
> setwd (paste("/home/oracle/scripts/R"))
> channel <- odbcConnect("test", uid="prod", pwd="passwd")

Traceback:

  1. .Call(C_RODBCDriverConnect, as.character(connection), id, as.integer(believeNRows))
  2. odbcDriverConnect(st, ...)
  3. odbcConnect("test", uid = "prod", pwd = "passwd") aborting ...

The below shows the changes in the odbcinst.ini file.

[ORACLE]

Description             = Easysoft ODBC Oracle Driver
#Driver         = /usr/local/easysoft/oracle/libesoracle.so
Driver          = /u01/app/oracle/product/11.1.0/db_1/lib/libsqora.so.11.1
#Setup          = /usr/local/easysoft/oracle/libesoraclesetup.so
DontDLClose             = 1
FileUsage               = 2


Can anyone point me to what I'm doing wrong?

Version of R = R version 2.8.0 (2008-10-20)

Cheers

Simon

Dr S J Collins
Grid data consultant
University Manchester



R-help_at_r-project.org 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. Received on Fri 28 Nov 2008 - 22:10:51 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 01 Dec 2008 - 15:30:29 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive