Yes, I am aware of that. RODBC connection is automatically shutting down without any warnings or error message. (That's why I jotted down Oracle error message when trying to reconnect).
I don't think it's a matter of Oracle since I've tested many query works simultaneously with multiple windows. I suspect RODBC's stability with multiple windows. Duncan Murdoch-2 wrote: > > On 05/01/2009 6:42 PM, jaey.ahn wrote: >> Hi, I encounter a problem when using more than 1 Rgui/Rcmdr with RODBC >> connection. >> As I use more than 1 RODBC connection with multiple Rgui/Rcmdr windows, >> my >> network connection (including internet) is shutting down. Thus the only >> solution to fix (so far) is to reboot the computer. >> >> I suppose RODBC is not compatible with more than 1 Rgui/Rcmdr, yet is >> there >> a way to avoid this problem? or at least, is there anyone who faces the >> same >> problem? >> >> The following is the error message when trying to reconnect through >> RODBC. >> >> [Oracle][ODBC][Ora]ORA-01041 internal error. hostdef ... > > That's a message from the Oracle ODBC driver, not from RODBC. Contact > Oracle. > > Duncan Murdoch > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- View this message in context: http://www.nabble.com/RODBC-connection-die---using-more-than-1-Rgui-Rcmdr-tp21301543p21303562.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
