similar to: Fwd: RODBC, sqlSave and sqlAppend

Hello, New user of R I did experience some trouble using R and ODBC on Windows XP, MS Access and PostgreSQL. While querying a database is relatively simple, the use of sqlSave is a bit more tricky. After a large series of trial, I finally succeeded to get it work provided : 1. I leave the application create the table by itself. Once created, reusing it is simple and reliable, although you

Brand new Mac OS X user, I am transfering my R stuffs from my windows machine. When porting some of my functions, I got messages such as : 2005-03-12 15:37:52.456 R[673] *** NSTimer discarding exception 'NSRangeException' (reason '*** NSRunStorage, _NSBlockNumberForIndex(): index (3607) beyond array bounds (2000)') that raised during firing of timer with target 3ba850 and

Dear All, As some of you in the archive, i am experiencing problems in using RODBC with IODBC on Mac OS X Panther. I am currrently facing two problems. The first one is apparently linked with IODBC (according to returned R error message) although testing the database access from IODBC manager seems to work fine. The second is by far more radical, R purely and simply reports an error ,

Hello, Brand new user of R that I want to interface with Windew (http://www.pcsoft.fr), I am looking for a detailed documentation of R(D)Com. Does anybody know where I can find it, or do you have any form of experience of the use of R with Windev? Thanks for your help. PS : As I am new to the group, people interested in some details about the requestor could find his resume at address

Hello all, I am planning to redeploy my workstation under KUBUNTU. Does any body has any r experience installing/using r on this platform? Best regards. -- Constant Depi??reux Managing Director Applied QUality Technologies Europe sprl Rue des D??port??s 123, B-4800 Verviers (Tel) +32 87 292175 - (Fax) +32 87 292171 - (Mobile) +32 475 555 818 (Web) http://www.aqte.be - (Courriel)

Hello all, I am planning to redeploy my workstation under KUBUNTU. Does any body has any r experience installing/using r on this platform? Best regards. -- Constant Depi??reux Managing Director Applied QUality Technologies Europe sprl Rue des D??port??s 123, B-4800 Verviers (Tel) +32 87 292175 - (Fax) +32 87 292171 - (Mobile) +32 475 555 818 (Web) http://www.aqte.be - (Courriel)

Hi all, I am currently trying to read, write and append data between R and MS access using the RODBC library functions. I have no problems reading in the data but when using sqlSave and sqlAppend it doesn't seem to work. I have made sure that all the column names are sensible and there are no gaps etc in the variables. My call looks like this: sqlSave(channel,treatlist,test=F) I've

Hello, I have a data crunching program which causes me a problem. Some of the data are identified with an & sign followed by a integer. No problem is experienced when analysing data below &500, but value above are ignored. Is there some limitation in R on this topic? Many thanks for your help. Best regards. Constant Depi?reux Managing Director Applied Quality Technologies

> De: Depiereux Constant <constant.depiereux at aqte.be> > Date: 12 mars 2005 09:44:08 GMT-05:00 > ?: r-help at stat.math.ethz.ch > Objet: [R] New user of R on Mac OS X - Please help > > > Brand new Mac OS X user, I am transfering my R stuffs from my windows > machine. > > When porting some of my functions, I got messages such as : > > 2005-03-12

Hello, I am still working at recovering from a few failed OS hard drives on my gluster storage and have been removing, and re-adding bricks quite a bit. I noticed yesterday night that some of the directories are not visible when I access them through the client, but are still on the brick. For example: Client: # ls /scratch/dw Ethiopian_imputation HGDP Rolwaling Tibetan_Alignment Brick: #

Dear all, One can use ks.test(x,y) for a one-sample kolmogorov-smirnov test: x being the data sample y being a string specifying a distribution I notice the help on ks.test does not tell you how to get such a list. Is this a hole in my R knowledge? Where can I get a list of the strings specifying the possible distributions? and more specifically What would be the string and following

Hi all, I am trying to use RExcel at the moment. I am able to get it to work for simple commands, but I can't seem to get it to work when I subset the data. So for example, if I start RExcel, and then 'Put R var' with the following: 1 1 2 2 1 2 3 1 2 4 1 2 5 1 2 6 1 2 7 1 2 8 1 2 9 1 2 10 1 2 and set it to variable x, then I 'run R' on the code 'z <- t(x)' and

Dear all, I have a multivariate dataset containing 100,000 or more points. I want find the p-value for the dataset of points coming from a particular multivariate normal distribution With mean vector u Covariance matrix s2 So H0: points ~ MVN( u, s2) H1: points not ~ MVN( u, s2) How do I find the p-value in R? To me this is a likelihood ratio test problem. In H0 the parameters are

Best fortress support was understandably dropped, but we still use them, and someone else may want the driver I ported to nut-2.0. We also often attach the serial cable from a UPS to a network terminal server, since servers these days don't come with very many serial ports. (They call them "legacy" ports.) I submitted a patch to support these for nut-1.x, and it was rejected

Hi, I try to use sqlSave to fill a date column in Oracle. value example: '05-JUL-03 13:35:09' sqlSave does not throw any error, but my table remain empty does anyone have experience with this ? Thanks, Marc Mamin

I am trying to save an R data.frame as an Excel sheet. I do NOT want the column names saved into row 1. I set colnames=F. However, it still seems that the colnames are saved into row 1. Is this a bug? Or am I coding incorrectly and.or misunderstanding this feature? #example code: sheet = "c:/test2.xls" temp=data.frame(matrix(data=NA,nrow=10,ncol=15)) temp[1,1] =

Hello, After a (bad) first try some months ago, I'm trying again to use RODBC package instead of DBI+RMySQL packages to populate MySQL database. The main command is sqlSave(channel, data_df, tablename, append=T, rownames=FALSE, colnames=FALSE, fast=FALSE, varTypes=vartypes) where data_df is the data.frame I want to save and vartypes is obtained following the tip given here

Dear R users, I have a follow-up question on sqlSave(). Since most of the output from the tests I use are lists, I would like to loop to export each element of the list and append it to the sheet. Here is what I do: > library(RODBC) > test <- structure(list(m = structure(c(0.090909090909091, 0.181818181818182, 0.272727272727273, 0.363636363636364, 0.454545454545455,

Hi, I'm able to establish a successful odbc connection using RODBC 1.3-2 on Win 7 and R 2.12.0. But I'm getting the following error message when I try to save a data frame into the debase as shown below. library(RODBC) bbdb <- odbcConnect("bbdb") odbcGetInfo(bbdb) # returns ok sqlSave(bbdb, USArrests, rownames = "state", addPK=TRUE) # example from the RODBC manual

Hello, I'm still trying to modify my script in order to use RODBC instead of RMySQL (no more ready-to-use package for windows). My new problem is the following one (not seen with RMySQL): I'd like to copy a data.frame to a mysql table. One column is a numeric one with big integer like : 2005000206110 (13 figures) If I type this number in R, I get: 2.005e+12 and when I use sqlSave to