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]] ______________________________________________ R-help@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.