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 at gmail.com
<mailto:pgilbert902 at 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 at gmail.com
<mailto:comtech.usa at 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 at gmail.com
<mailto:comtech.usa at 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 at r-project.org <mailto:R-sig-DB at r-project.org>
https://stat.ethz.ch/mailman/__listinfo/r-sig-db
<https://stat.ethz.ch/mailman/listinfo/r-sig-db>