[R-sig-DB] oracle database connection issue from R in Linux

[sasidhar M]

Hi,

This is sasi.
I installed R 64 bit and oracle client 64 bit in fedora 17. After R is
working fine. Oracle database also working fine. but problem is, If i try
to connect oracle from R its not connecting.
So, pls guide me how to connect from R to oracle.


how, i tried:--

odbcinst.ini file code is

[ORACLE2]
Description = oracle driver
Driver = /ibexis/app/oracle/product/11.2.0/db_1/lib/libsqora.so.11.1
DontDLClose = 1
FileUsage = 1
UsageCount = 1


I tried in R ...
>library(RODBC)
>con <- odbcConnect("data source name", uid="username", pwd="password")

after this line i got error,

> odbcConnect("india", uid="data_quality", pwd="data_quality")
[1] -1
Warning messages:
1: In odbcDriverConnect("DSN=india;UID=data_quality;PWD=data_quality") :
  [RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver
Manager]Can't open lib '/ibexis/app/oracle/product/
11.2.0/db_1/lib/libsqora.so.11.1' : file not found
2: In odbcDriverConnect("DSN=india;UID=data_quality;PWD=data_quality") :
  ODBC connection failed

Please help me .
Iam eagerly waiting for reply

	[[alternative HTML version deleted]]