similar to: R, postgresql, windows & bsd

Dear R users, I am trying to connect R to data that is in a Access Database but I have problem with the construction of queries using special characters. I am using RODBC package. The following is working : > MyQuery<-paste("SELECT first( (DateHeure) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM Colonne_3 ") > Col3<-sqlQuery(con, query=MyQuery) > Col3

Context:Linux debian testing, compiled R 1.9.0 from source. I've just installed the contributed ffnet package wit no problem at all. But when loading the library the following error message is popping up and no ffnet command seems to work: >library("ffnet") Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

Hello, Q/ Is it possible to create a DBMS connection automatically on startup of R? (Making sure of course that the db server has been started...) I am running MySQL on Mac OS X 10.4.2 with R2.4.1. I have tried to write a function using the RMySQL commands (below) and place them in .First of .RProfile: drv <- dbDriver("MySQL") dbcon <- dbConnect(drv, {other parameters present in

Context: Windows XP, R 1.8.1 I'm studying Venables-Ripley "MASS" book and having a go at the many examples in library MASS. The code I'm checking (from script ch04.R) now is ...... data(swiss) splom(~ swiss, aspect = "fill", panel = function(x, y, ...) { panel.xyplot(x, y, ...); panel.loess(x, y, ...) } ) which produces an agreable plot with a gray

I have defined a daily timeseries for the 365 days of 2003 issuing: myts = ts(dati[,2:10],frequency=365,) > myts Time Series: Start = c(1, 1) End = c(1, 365) Frequency = 365 and mytime = as.POSIXct(strptime(as.character(dati[,1]),format="%Y-%m-%d")) contains the dates from "2003-01-01" to "2003-12-31" How can I combine mytime and myts in order to list

I receive the following meteo dataset regularly, containing the average daily temperatures (tMedia) of a certain month for 24 selected meteo-stations (COD_WMO) whose human-readable names are in (NOME). str(tabella) `data.frame': 1038 obs. of 4 variables: $ COD_WMO: int 16045 16045 16045 16045 16045 16045 16045 16045 16045 16045 ... $ NOME : Factor w/ 24 levels

Context: Windows XP - R 2.0.1 with the latest updated packages (including Rcmdr) I'm trying to load Rcmdr to use the 3d plots (e.g. scatter3d) but here it is what happens: > library(Rcmdr) Loading required package: zoo Loading required package: strucchange Loading required package: sandwich Loading required package: relimp Loading required package: mvtnorm Loading required package:

Hello, I'm using R 2.3.1 on Windows. I'm generating some very long SQL statements. I do this by using paste() which will contain many strings and variables. I'm getting an error when the the total line length is longer than about 1013 characters. For example, it works with the line containing 1013 characters and not when it is 1059. I've looked into adjusting the

I use linux debian testing for which the latest debianized version of R is 1.8.1. Therefore I installed: r-base-core_1.8.1-0.cran.1_i386.deb r-base-dev_1.8.1-0.cran.1_all.deb r-base-html_1.8.1-0.cran.1_all.deb r-base-latex_1.8.1-0.cran.1_all.deb r-base_1.8.1-0.cran.1_all.deb r-doc-html_1.8.1-0.cran.1_all.deb r-doc-info_1.8.1-0.cran.1_all.deb

At office I'm cautiously introducing R to be used as the basic statistical program, getting rid of licensed stuff or reducing the amount of it. The aim of R would be to run generic statistical programs built & "consumed" when needed and some static procedure dealing with time-series. Now, we have substantially 3 OS platforms, win xp, linux and freebsd 5.4, on similar PCs (pentium

I have been using RODBC for a while with no complaints (R 2.0.1 patched under WinXP), then I saw a link (http://grass.itc.it/statsgrass/r_and_dbms.html) showing that Rdbi claims to run a query in 5 seconds that takes RODBC 4.3 minutes. That was hard enough for me to believe that I wanted to try some tests myself, but I cannot get Rdbi to connect to my ODBC database. Here is what works for RODBC

Hi, I would like to be able to use R with a connection to a PostgreSQL database. I am using R 2.0.1 on windows XP. I have tried installing both the DBI and rDBI packages (which is better?) but in either case I run into the same problem - when i try to use either the dbDriver or dbConnect functions i'm told the function couldn't be found. Seems like the packages aren't installing

one more bit of information about this problem. If I start R as the user "postgres" i dont have the segmentation fault. ---------- Forwarded message ---------- Date: Wed, 5 Feb 2003 19:19:39 -0500 (EST) From: Rafael A. Irizarry <ririzarr at jhsph.edu> Reply-To: rafa at jhu.edu To: "R-Help (E-mail)" <r-help at r-project.org> Subject: rdbi segmentation fault hi! i

Hi all, I tried to install the Rdbi_0.1-2.tar.gz and Rdbi.PgSQL_0.1-2 package. The Rdbi_0.1-2.tar.gz installed fine but the Rdbi.PgSQL_0.1-2 had some problems. The compilation routine tried to find a header called libpq-fe.h but did not find it in the standard locations. I searched through the computer but did not find a file called in this way either. What should I do to successuffly

I can use the Rdbi package to connect to a PostGreSQL server fine but when I use the dbDisconnect(), I get a segmentation error and it throws me out of R. I'm using RH7.2, R1.4.1, Rdbi 0.1-2, and Rdbi.PgSQL 0.1-2. Anyone else seen anything like this and have an possible answer? Andrew Schuh -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing

Hi all, ------ I tried to use * over satellite, but all my effort did not succeed. The Asterisk is behind the VSAT and is resposibel for alle the SIP clients in a field location. The clients are notebooks and PDA's running SJPhoen for Windows and PocketPC. Unfortunately I could not find any Linux Client wich worked satisfying. SJ LAbs promised a Linux Version at the end of August but they

Hi R-listers, I am new to R and programming. I have a large dataframe composed of two grouping variables (species, population, with populations nested in species) and tens of continuously numeric variables. For each numeric variable, I want to make a boxplot with population as the X axis and the boxes filled according to which species it is belonging to. But, that is a definitely tedious work. I

Hello R users, I found the odfWeave package to create an odf document. It seems to be a very nice tool. So i tried to used it to create a report with multiple plot: I create an odt file with some code inside: I connect to a mysql database I get a list of projects foreach project I would like to make a plot (a map exactly) then in a R console I use the odfweave (inFile, outFile) function.

I want to set a variable number and type of ValueRangeProcessors at run time based on a configuration file. But I seem to be running into (what I think is) a C++ scope issue. I tried just a simple test to see if I could add 5 VPs in a loop. Xapian::QueryParser qparser; Xapian::Query query; int vp = 0; while(vp < 5) { Xapian::StringValueRangeProcessor sproc(vp++);

I have used RODBC to get the database i can view the tables in RGUI-2.4.1 how can i query the records in R> i tried with sqlQuery need some help JJ -- Lecturer J. Joshua Thomas KDU College Penang Campus Research Student, University Sains Malaysia -- Lecturer J. Joshua Thomas KDU College Penang Campus Research Student, University Sains Malaysia [[alternative HTML version deleted]]