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 <pgilbert...@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]] _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db