Displaying 1 result from an estimated 1 matches for "sqlexecdirects1000".
Did you mean:
sqlexecdirect37000
2005 Aug 17
1
RODBC and sqlColumns
...reate a new table but returns
Error in sqlColumns(db, "X.test") : 'X.test': table not found on channel
It seems to be having problems with what is returned by the
columns.....since
Error in sqlSave(db, aDataFrame, "X.test", T, F) :
[RODBC] ERROR: Could not SQLExecDirectS1000 7 ERROR: relation
"test" already exists
but if I change the input table to be different....then R can create the
table, but fails to populate it. I checked the db in PgAdmin and the
table is created by the sqlSave call. All this stuff works if I don't
use a schema "schema.tab...