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<e...@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@r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-debian
>
_______________________________________________
R-SIG-Debian mailing list
R-SIG-Debian@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-debian
