There are several different ODBC drivers out there for R:base. R:base for Windows comes with a trimmed down version and I have not used it at all. I really don't know the difference between it and the full version of Oterro, but there are some major differences.
Now my experience is with using the latest version of Oterro along with Tango and VB. When you are using Tango, you set the ODBC connection up on your web server and then Tango access your database through the ODBC connection. Tango does not care what database is on the other side as long as the structure is what it expects to see. You can set up several data sources up and access them at will. You can also write Tango apps to query the structure and data in the database at will, essently giving you an R> to the database through a Tango web page. I have not tried making structure changes through Tango, for 1 reason I run with static set on, so I would have to figure out how to disconnect, turn it off, and then re-connect to the database to do it. It is easier to just walk to the hall, stop the Tango server, to into R:base and make my changes. Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 2/13/02 10:06 pm >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/ ================================================ 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/
