R-sig-Debian help,
I have installed an ODBC Driver for Linux.
I want to connect to our database through R via:
>library(RODBC)
>con <-
>odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS")
Warning message:
In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") :
ODBC connection failed
I don't really know whether this is the right syntax. I copy-paste files
"odbc.ini" and "odbcinst.ini":
## file odbc.ini
[ORACLE]
Driver = ORACLE
Database = //IP_address:PORT/MAGNUS
User = my_username
Password = my_password
METADATA_ID = 0
ENABLE_USER_CATALOG = 1
ENABLE_SYNONYMS = 1
## file odbcinst.ini
[ORACLE]
Description = Easysoft ODBC Oracle Driver
Driver = /usr/local/easysoft/oracle/libesoracle.so
Setup = /usr/local/easysoft/oracle/libesoraclesetup.so
DontDLClose = 1
FileUsage = 1
UsageCount = 1
Thanks in advance
_______________________________________________
R-SIG-Debian mailing list
R-SIG-Debian@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-debian
