[R] RODBC help

pirar01 armand.pirvu at gmail.com
Tue Jan 25 04:34:47 CET 2011


I am new in the R world and hopefully this is the right forum to ask.

My backend is an Ingres database to which I connect via ODBC

I have defined a DSN which connects ok to myh backend

But when I try the following
channel <- odbcConnect("pirar01")
sqlSave(channel, a, tablename = "Table1", append = FALSE, rownames = FALSE,
colnames = FALSE, verbose = TRUE)

It fails:

Query: INSERT INTO "Table1" ( "strategy", "par1", "par2", "par3", "par4",
"par5", "par6", "timeinmarket", "totalprofit", "annualizedreturns",
"annualizedvol", "informationratio", "ewar", "maxdd", "sp500corr",
"rsquared", "avgholding", "maxholding", "meanmktdayreturn",
"probmktdayprofit" ) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )
Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test,  : 
  missing columns in 'data'

The table gets created but it is empty

Any ideas , suggestions ?


View this message in context: http://r.789695.n4.nabble.com/RODBC-help-tp3235377p3235377.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list