Displaying 3 results from an estimated 3 matches for "schemaname".
2008 May 05
2
RODBC and schemas
I have found that the "schema.table" syntax used in Postgresql (and
Oracle) does not work directly with RODBC.
This works
library(RODBC)
con<-odbcConnect("mydb")
d<-sqlQuery(con,"select * from meso.trees")
However this does not.
d<-sqlFetch(con,"meso.trees")
Error in odbcTableExists(channel, sqtable) :
?meso.trees?: table not found on channel
2006 Jun 30
0
Setting default schema with Oracle
I wish to avoid putting the schema name inside each model class.
set_table_name "schemaName.tableName"
In Oracle one does this with the following statement ...
alter session set current_schema = ApplicationDatabaseAccount;
How do I do this for the connection Rails makes for me?
How do I control the size of the connection pool?
Thanks,
Dennis Byrne
-------------- next part -----...
2007 Nov 07
1
Dealing with schema in RODBC
Is there a way to get a table in a certain schema? The Oracle database I am
using has a table by the same name in two different schemas. This creates
problems in sqlUpdate because to sqlUpdate there are duplicate columns. The
following is part of the output of sqlColumns:
sqlColumns(eids, "TEST_ARTCL_INST")[,1:4]
TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME
1