R-sig-DB Digest, Vol 58, Issue 5
Hello Luis,
Have you tried setting the Servername explicitly in your call to
'odbcDriverConnect()'?
Can you get the following to work: > con <-
odbcDriverConnect("SERVER=*******";DRIVER=ORACLE;DATABASE=MAGNUS")
Stephen Weller
Revolution Computing
On Fri, Aug 14, 2009 at 3:00 AM, <r-sig-db-request at stat.math.ethz.ch> wrote:
Send R-sig-DB mailing list submissions to
r-sig-db at stat.math.ethz.ch
To subscribe or unsubscribe via the World Wide Web, visit
https://stat.ethz.ch/mailman/listinfo/r-sig-db or, via email, send a message with subject or body 'help' to r-sig-db-request at stat.math.ethz.ch You can reach the person managing the list at r-sig-db-owner at stat.math.ethz.ch When replying, please edit your Subject line so it is more specific than "Re: Contents of R-sig-DB digest..." Today's Topics: 1. In odbcDriverConnect ODBC connection failed (Luis Ridao Cruz) ---------------------------------------------------------------------- Message: 1 Date: Thu, 13 Aug 2009 16:25:55 +0100 From: "Luis Ridao Cruz" <Luisr at hav.fo> Subject: [R-sig-DB] In odbcDriverConnect ODBC connection failed To: <r-sig-db at stat.math.ethz.ch> Message-ID: <4A843E930200008700000D18 at mail.elektron.fo> Content-Type: text/plain; charset="US-ASCII" R-sig-DB 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-DB mailing list R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db End of R-sig-DB Digest, Vol 58, Issue 5 ***************************************