You are sooooo......................right about the speed issue. I don't have a clue as to why, but the when I do a search on a table in another database, depending on the column I use, the search can be a little slow, to unbelievably slow, but the "dump it to an ascii file" workaround works great. Also, I have noticed that sometimes, when I change the structure of the foreign database, I get errors until I delete and recreate the ODBC connection. Is the ODBC driver in Tango better/faster/different etc than the ODBC connection in Rbase for Windows??
Mike Sinclair Troy Sosamon wrote: > Mike, > > If you change structure, you do NOT have to re-install the ODBC driver. It > evaluates the structure when the ODBC connection is used. > > If you are using large datasets from R:base, it is faster to disconnect from > one database, connect to the second one, dump the data to a file, connect to > your primary database, create a temp table, load the data into the temproary > table, and use it from the temp table. If you are not using large datasets, > you probably wouldn't have it in sepearte databases to start with. > > Now if you are using Tango, you can set up your web server to use as manay > databases as you want. I am sure there is a limit, but I am using 6 or so w/o > any problems. > > Troy > > >===== Original Message From [EMAIL PROTECTED] ===== > >Hi everybody, > > > >If you want to use data from two different databases, and hook them together > >with ODBC, do you need set up the ODBC connection at each individual > >workstation? If so, is there a way to do that without physically going to > each > >workstation? Like wise, if you change the structure of one or both of the > >databases, do you have to delete and reinstall the ODBC setup at each > station? > > > >TIA! > > > >Mike Sinclair > > > >================================================ > >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/ > > Troy Sosamon > Denver Co > [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/
