[R] RODBC connections w/o specific database

Bruno C.
2007-04-16T19:23:00Z

Hello,
If it is not a problem for ODBC, you can use an SQL statemente to change the DB:
"use NAME_OF_DB"

> Folks,
>
> I'm writing a gui wrapper around RODBC (having abandoned RMySQL) and
some custom analysis scripts.  I'm hoping that I could get some advice.
>
> All of my users will have access to a database server.  I am going to limit
their access to certain databases--a sizeable warehouse in a SAN, and then
smaller storage that they can use for temp files and personal tables.  I want to
present these to the user using a tktree widget, rather like you might see in
Enterprise Guide, with the top level of each tree being a specific database and
branches being tables.
>
> Can I get some advice on a good way to accomplish this?
>
> Right now I can create and connect to a DSN that does not specify a
database.  I suppose that upon connection I could use sqlQuery to get the names
of databases and their tables, then use the result to populate the tree.
However, once a table has been selected, would I need to create a new connection
(since the existing connection does not specify a database) or could I use the
existing one for everything and just specify database and table in my queries?
>
> Also, any additional advice on would be appreciated if anyone has any.
>
> Thanks,
>
> Pete
>
>
> ---------------------------------
>
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch 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.
>


------------------------------------------------------
Leggi GRATIS le tue mail con il telefonino i-mode? di Wind