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
Thanks & Regards
M.Sasidhar
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
