All, I am new in R. I found sqlSave() doesn't work for our Oracle9i. The following was the message:> sqlSave(channel, USArrests, rownames="state")Error in sqlColumns(channel, tablename) : USArrests : table not found on channel Check case parameter in odbcConnect>sqlQuery() works OK. Please help. Thanks. -MY
On Fri, 4 Apr 2003, Minghua Yao wrote:> I am new in R. I found sqlSave() doesn't work for our Oracle9i. The > following was the message: > > > sqlSave(channel, USArrests, rownames="state") > Error in sqlColumns(channel, tablename) : USArrests : table not found on > channel > Check case parameter in odbcConnect^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ It tells you what to do, so please do it! Also, I trust you have read ?odbcConnect and understood what it says about Oracle? -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
Hi, I asked the same question to this list previously this week. The solution to the problem may be to use the 'case' argument to odbcConnect. See my previous post as well as the reply by Prof. Ripley. /Fredrik Karlsson On Fri, Apr 04, 2003 at 04:57:59PM -0600, Minghua Yao wrote:> All, > > I am new in R. I found sqlSave() doesn't work for our Oracle9i. The > following was the message: > > > sqlSave(channel, USArrests, rownames="state") > Error in sqlColumns(channel, tablename) : USArrests : table not found on > channel > Check case parameter in odbcConnect > > > > sqlQuery() works OK. > > Please help. Thanks. > > -MY > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help