[R] RODBC connection die - using more than 1 Rgui/Rcmdr

[jaey.ahn]

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 at 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.