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/
