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

[Michael]

Thank you!

In order to identify which library is used by RStudio, I have actually done
the following in RStudio:

> aa=Sys.getenv("LD_LIBRARY_PATH")
> bb=gsub("odbc", "xxxx", aa)
> cc=gsub("ODBC", "XXXX", bb)
> Sys.setenv(LD_LIBRARY_PATH=cc)

Amazingly, all the programs still worked in RStudio...

So at least for RStudio, LD_LIBRARY_PATH is not used for RODBC, as you
pointed out earlier...

Then what shall I set up for running the same program in R-Console?

What are the key elements that are in RStuio but missing in R-Console?

I have also made sure the RStudio and R-Console have the same underlying by
checking:

R.Version
R.home()

in both R-Console and RStudio...

Any more thoughts? Thanks a lot again!



On Mon, May 28, 2012 at 8:01 AM, Paul Gilbert <pgilbert902 using gmail.com> wrote:

> I think it would be useful to first understand how your RStudio
> environment is working. You should not need both "/pp64/odbc/5.3/lib" and
> "/pp64/odbc/5.1/lib" on your LD_LIBRARY_PATH. One can guess what is being
> used, but it would be better to be certain. So if you can get a relatively
> clean RStudio environment that works, then deciding what to use in the
> console session would be easier.
>
> Once again, while the crash to the shell with no error messages may not
> happen until you execute some R commands, this behaviour is almost
> certainly related to loading a bad binary file or library.
>
> (Also, be certain you are getting the same version of R and package
> libraries when you run RStudio and your console session.)
>
> Paul
>
>
>

	[[alternative HTML version deleted]]