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