In odbcDriverConnect ODBC connection failed
Is there a reason you don't want to use the ROracle driver? It has worked quite well for me at other firms (we don't have oracle here). -Whit
On Wed, Aug 12, 2009 at 9:47 AM, Dirk Eddelbuettel<edd at debian.org> wrote:
On 12 August 2009 at 13:23, Luis Ridao Cruz wrote:
| 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
I only briefly worked with Oracle and as I recall you needed another layer of
naming indirection.
You may want to test the basics of RODBC with an ODBC-driven db you can
control (mysql, postgresql, sqlite, ...) to ensure that that part works, and
then try to work out the Oracle specific bits, maybe with help from r-sig-db.
Dirk
--
Three out of two people have difficulties with fractions.
_______________________________________________ R-SIG-Debian mailing list R-SIG-Debian at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-debian