[R-sig-DB] RODBC connection to Oracle on 64-bit RHEL box failing

Sean O'Riordain @e@npor @end|ng |rom @cm@org
Sat Apr 24 10:39:47 CEST 2010


Have you considered using RJDBC instead of ODBC?  I don't know about
the relative performance - but I've no problems using jdbc from 64-bit
ubuntu to oracle on 32/64 bit redhat.

In the past I gave up on using odbc due to the difficulty in setting
it up... jdbc is a piece of cake by comparison and doesn't require
system changes only a local copy of the ojdbc14.jar (from memory) to
be accessible.

cheers,
Sean


On Wed, Mar 24, 2010 at 4:02 PM, Harlan Harris <harlan using harris.name> wrote:
> On Wed, Mar 24, 2010 at 10:53 AM, Marc Schwartz <marc_schwartz using me.com>wrote:
>
>> Interesting. Monroe is the guy that I had communicated with last year on
>> this point. Presumably either they were not yet ready to announce anything
>> and/or it was still on their TODO list.
>>
>> Can the 64 bit driver co-exist with the 32 bit driver or is it a choice of
>> one or the other? In other words, can I create 32 bit and 64 bit DSN's
>> separately, so that I can use either 32 bit or 64 bit R as I may need
>> interchangeably?
>>
>
> I have no idea! :)
>
>
>> I would certainly never speak for Prof. Ripley, but I can tell you that
>> during my 8+ years of using R, whether it be via onlist postings or my
>> periodic offlist communications with him, I have never had a reason to doubt
>> his availability or responsiveness when it comes to anything R related,
>> whether that be 'base R' as a member of R Core, or the other packages that
>> he maintains. That experience includes both day and night for any given time
>> zone...
>>
>
> In theory I agree, but if (heaven forbid) Prof. Ripley were hit by a bus,
> this could never get fixed. That's not true for R as a whole (see that
> interesting article in a recent R Journal), but it is true for a number of
> non-core packages... And Oracle is not very high on the list of databases
> used by R's core user base!
>
>
>> I checked the archives and at least recently, don't see a post here from
>> David after late 2008, but I would not hesitate to send him an e-mail
>> directly, which appears to be daj025 using gmail.com or dj using bell-labs.com.
>>
>
> Ah, thanks, will do.
>
>  -Harlan
>
>
>>
>>
>> Marc
>>
>>
>
>        [[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>




More information about the R-sig-DB mailing list