SOS! R Console crashed after loading RODBC... Update: Re: How to set up RODBC? Diff between R Console and RStudio?
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 at 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