[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]

(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>  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>  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
> https://stat.ethz.ch/mailman/listinfo/r-sig-db