[R-sig-DB] R-sig-DB Digest, Vol 58, Issue 5

[Stephen Weller]

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 using stat.math.ethz.ch> wrote:

> Send R-sig-DB mailing list submissions to
>        r-sig-db using 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 using stat.math.ethz.ch
>
> You can reach the person managing the list at
>        r-sig-db-owner using 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 using hav.fo>
> Subject: [R-sig-DB] In odbcDriverConnect   ODBC connection failed
> To: <r-sig-db using stat.math.ethz.ch>
> Message-ID: <4A843E930200008700000D18 using 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 using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
>
> End of R-sig-DB Digest, Vol 58, Issue 5
> ***************************************
>

	[[alternative HTML version deleted]]