search for: rsqliite

Hi, R-help group, I kinda meeting a question when using R-2.12.0(Previous version is 2.10.0): When I typed "library("Biobase")", everything is alright! But when I type "library("genefilter")", it doesn't work! And echo this: Error in library.dynam(lib, package, package.lib) : DLL 'RSQLite' not found: maybe not installed for this

Dear all, I would like R to retrieve a table resulting from execute sql stored procedures. What function can I use? Can RODBC do it. I tried channel1 <- odbcConnect("ptsecmstqa01-alpha") query <- paste("execute DB.dbo.usp_test") Data<- sqlQuery(channel1, query) However, it returned blank. Best Regards, Suphajak Ngamlak Equity and Derivatives Trading Phatra