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 > > ______________________________________________ > [EMAIL PROTECTED] mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
