[R-sig-DB] SOS! R Console crashed after loading RODBC... Update: Re: How to set up RODBC? Diff between R Console and RStudio?

[Paul Gilbert]

If they are both installed, I think they are in directories like 
/usr/lib/i386-linux-gnu/ and /usr/lib/x86_64-linux-gnu/. If they are not 
both installed, then that could not be the problem. Try
   locate libodbc.so
to see what you have installed.


On 12-05-27 07:58 PM, Michael wrote:
> Thank you Paul.
> How do I judge/check which lib is 32 and which is 64?
> Thanks again!
>
> On Sun, May 27, 2012 at 6:45 PM, Paul Gilbert <pgilbert902 using gmail.com
> <mailto:pgilbert902 using gmail.com>> wrote:
>
>     (Cross posting should not be done!)
>
>     A crash to the shell prompt suggests a bad .so got loaded. Maybe you
>     are picking up a 32 bit version instead of 64 bit, or the reverse. I
>     am surprised you need to set  LD_LIBRARY_PATH, and if you set it
>     wrong it might cause this. (Just guessing.)
>
>     Paul
>
>
>
>     On 12-05-27 01:26 PM, Michael wrote:
>
>         On Sun, May 27, 2012 at 11:32 AM, Michael<comtech.usa using gmail.com
>         <mailto:comtech.usa using gmail.com>>  wrote:
>
>             Help! The R Console very quietly closed and exited without
>             giving any
>             errors/warnings...after I loaded the RODBC library...
>
>             Loading required package: RODBC
>
>
>
>
>             On Sat, May 26, 2012 at 10:27 PM,
>             Michael<comtech.usa using gmail.com
>             <mailto:comtech.usa using gmail.com>>  wrote:
>
>                 Hi all,
>
>                 It's very strange. In RStudio, I can successfully
>                 load("RODBC"). But in
>                 the plain R Console, I just couldn't get it work:
>
>                 (For some special and important reasons, I have to make
>                 the RODBC work in
>                 R Console, not the RStudio.)
>
>                 At first, the some shared library "libodbc.so" couldn't
>                 be found... it's
>                 right there, but R Console just couldn't find it.
>
>                 I then find that the
>
>                 Sys.getenv("LD_LIBRARY_PATH") is different for R Console
>                 vs. RStudio.
>
>                 Weirdly, the LD_LIBRARY_PATH in RStudio even doesn't
>                 have any "ODBC"
>                 terms/words in its long string...
>
>                 I guess RStudio has some special configuration for
>                 RODBC, so it doesn't
>                 require LD_LIBRARY_PATH to be set up for ODBC at all.
>
>                 I then added the ODBC library path into the
>                 LD_LIBRARY_PATH in R Console.
>
>                 I found that this problem is solved...
>
>                 But then the R Console complained that the "ODBCINI" was
>                 set up correctly.
>
>                 So I compared the "ODBCINI" in RStudio vs. "ODBCINI" in
>                 R Console, found
>                 the R Console one seems to be missing.
>
>                 I then copied the "ODBCINI" from RStudio and pasted it
>                 into R Console.
>
>                 Now the load("RODBC") can run in the plain R Console,
>                 but then the whole
>                 R console crashed without giving any errors/warnings...
>
>                 It exited back to the shell prompt...
>
>                 What can I do? Anybody please shed some lights on me on
>                 this?
>
>                 Thanks a lot!
>
>
>
>
>                 [[alternative HTML version deleted]]
>
>         _________________________________________________
>         R-sig-DB mailing list -- R Special Interest Group
>         R-sig-DB using r-project.org <mailto:R-sig-DB using r-project.org>
>         https://stat.ethz.ch/mailman/__listinfo/r-sig-db
>         <https://stat.ethz.ch/mailman/listinfo/r-sig-db>
>
>