Emmitt, I have not tested it, but I am sure you will want to use the Oterro connection. You can connect to an R:base database w/ sconnect w/o any ODBC driver at all, but it is very slow. If you need very much data, it is faster to disconnect one database, connect to the other one, dump the data out to a file, go back to the original database, connect to it and load the data in.
The Oterro database connection is just about as fast as a native R:base connection, but w/ Oterro you can connect to several datasources at once w/o any performance changes. Now I have not tried connecting from an R:base database via Oterro to a second R:base database, but I have connected from an R:base database using other ODBC data sources and linking the tables into R:base. Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 10/02/02 1:53 pm >On a given server we have an R:Base job running that SCONNECTs another >R:Base database. The R:Base ODBC driver is installed, and all this works fine. > >Now I need to install Oterro for a separate process on this server. > >The question is, for connectivity between an R:Base task and another R:Base >database, will I get better results using the R:Base ODBC driver or >Oterro? In my scenario I could redefine the DSN to use the Oterro driver, >or I can leave it as an R:Base ODBC connection. > >Does anyone have any data to support one or the other of these two >possibilities? Is there any practical difference? > > > >Emmitt Dove >Manager, DairyPak Business Systems >Blue Ridge Paper Products, Inc. >40 Lindeman Drive >Trumbull, CT 06611 >(203) 673-2231 >[EMAIL PROTECTED] >[EMAIL PROTECTED] > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
