Displaying 1 result from an estimated 1 matches for "data_base_02".
Did you mean:
data_base_01
2009 May 13
3
SQL Queries from Multiple Servers
...DBC as my conduit from R to SQL. It works well when the tables are
stored on one channel, e.g.,
channel <- odbcConnect("data_base_01", uid="....", dsn="....")
However, I often need to match tables across multiple databases, e.g.,
"data_base_01" and "data_base_02". However, odbcConnect() appears limited
insofar as you may only query from tables within a single channel, e.g.,
database. I do not have access to write and create new tables on the SQL
servers, which is a possible solution (e.g., copy all tables into a single
database).
Is there any way, in...