On 05/01/2009 9:26 PM, jaey.ahn wrote:
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.
That would be a bug, so you should put together a simple example to
reproduce it. Avoid Rcmdr, try to just use Rgui and RODBC. The big
problem will be the database: if your example requires Oracle, only
someone with Oracle will be able to debug it, so try to put together a
generic example that works with any database with an ODBC driver.
I still suspect Oracle here (it did say "internal error" after all), so
please do demonstrate it on some other database before you conclude it's
an RODBC problem.
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.
