similar to: RMySQL for R1.8.1 on Windows

Hello all, I'm looking for the R-equivalent of the S-option "Connect type: half horiz first". Link: http://miner.stern.nyu.edu/Splus/help/guihelp/__hhelp/connect_type.htm I'm plotting with type="s" or type="S"; this is giving me a stairstep starting, or ending with the value on the x-axis (as documented). But, I want the x-value in the middle of the step,

Hi group, I try to write a frame to a table (RODBC). I use colnames(temp6) <- c("ind_id","ser_id","period_id","year","calc","mean") sqlSave(channel, temp6, tablename = "series_indices_test",append= TRUE, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in

Hi group, suppose I have a date, say May 15 2004, and I want to now what date it is 23 days before that date. The way to calculate the new date should (...) take account of leap years :) In pseudocode: olddate <- "May 15 2004" newdate <- olddate-23 I looked around in POSIXct etc..., maybe I overlooked? Thanks, Maarten

Being relatively new to R, I want to use R in connection with a MySQL database. After installing (apparently sucessfully) the package RMySQL (R Version 1.6.2) the result is as follows: > library(RMySQL) > con <- dbConnect(MySQL(), dbname= "test") Error: couldn''t find function "dbConnect" Thank You in advance for help Peter Jörg Peter Baresel Technische

Hi R users, I have been trying to install and use RMySQL on Windows98 for MySQL3.23.55-max using the pulldown menu. I am getting the following errors. I read the doc and some archived mails about a similar problem on unix like systems. Still can't get it to work. Some info below that may indicated where the problem is: * The directory RMySQL\libs is empty---I was not expecting this. *

I have justed upgraded R v1.7.0 on Windows NT 4 and have installed the latest RMySQL (version 0.5-1)and DBI (version 0.1-5) packages. When I issue the following commands (tactfully adjusted) R just crashes and disappears, any ideas? require(RMySQL) m <- dbDriver("MySQL") con <- dbConnect(m, dbname="xxx", user="xxx", password="xxx",

I have tried to install the RODBC package with the next command: > install.packages(("ORDBC"), (lib="usr/lib/R/library")) But it is failed. Can I get some information about the installation of this package anywhere? Best regards, Nader -------------------------------------------------------------- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html

Hello, It is very simple question. I want to go to the parent directory and give the 'system("cd ../") commnad. But it stayes at the same dirctory as before. Do I forget to give some extra parameter to system command in this case? Regards, Nader -------------------------------------------------------------- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html

Hi, I have problems installing RMySQL under R1.8.1 and RHlinux (kernel2.4.7). During compilation I get: ** libs gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -m486 -fno-strength-reduce -g -c RS-DBI.c -o RS-DBI.o gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -m486

Hi, I am brand new to the world of R, so please bare with me while I goof my way through a question. I am attempting to trial using R with MySQL. The MySQL server is on a Linux box and I am using the Windows (32bit XP) version of R. I have installed RMySQL successfully, however when I load it I get the error: Error : .onLoad failed in loadNamespace() for 'RMySQL', details: call:

Hi, I have a problem loading RMySQL 0.5-5 on Mac OS 10.4.2 running R 2.1.1. I installed RMySQL using: export PKG_CPPFLAGS="-I/usr/local/mysql/include" export PKG_LIBS="-L/usr/local/mysql/lib -lmysqlclient" R CMD INSTALL /Users/gwo/Desktop/RMySQL_0.5-5.tar.gz The installation seemed to work ok, but when I load RMySQL in R I get an error message: >library(RMySQL)

Hi, I am having problems loading RMySQL. I am using MySQL 5.0, R version 2.5.1, and RMySQL with Windows XP. When I try to load rMySQL I get the following error: > require(RMySQL) Loading required package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library 'C:/PROGRA~1/R/R-25~1.1/library/RMySQL/libs/RMySQL.dll': LoadLibrary

I had installed R and MySQL ,then I input : > install.packages('RMySQL',type='source') show the message below, Why? Why shows "ERROR: configuration failed for package 'RMySQL'"? ??URL?http://mirrors.xmu.edu.cn/CRAN/src/contrib/RMySQL_0.9-3.tar.gz' Content type 'application/x-gzip' length 165363 bytes (161 Kb) ???URL downloaded 161 Kb *

I just installed RMySQL 0.5-9 with R 2.4.0 on Windows XP and got the following error message when trying to run a script with RMySQL: Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed < 2.0.0? Any ideas? Thanks, Frank

What do I need to do to load the RMySQL library on Win 2K using version 1.8.1 I have Mysql v4.0.16 up and running on the local machine with several databases running fine. Using RGUI I have loaded RMySQL and an appropriate directory structure has appeared under C:\Program Files\R\rw1081\library\RMySQL I have added C:\Program Files\R\rw1081\library\RMySQL\inst\libs to my path variable so that

Dear All, I am having a bit of problem using the DBI and RMySQL package. I have already installed DBI but now I want to connect to MySQL. So how do I do it. The CRAN package repository does not have RMySQL windows binary to install from? Regards, Indrajit Sen Gupta Business Analyst Mu Sigma Business Solutions Pvt Ltd #21/1-1, Nawab Towers Cunningham Road Bangalore 560 052, India Tel: +91 80

Dear Group, I'm having lots of problems getting RMySQL on a 64 bit machine. I followed all instructions available but couldn't get it working yet! Please help. See the output below. I did a install of RMySQL binary from the revolution cran source. It seems to have unpacked fine but gives this error when I call RMySQL Error: package 'RMySQL' is not installed for 'arch=x64'

Folks, I failed to create a connection to the database under MySQL DBMS in the R system via RMySQL's method dbConnection(...). My setup is as follows: Microsoft Windows XP 5.1.2600 MySQL 4.1.9 R 2.0.1 DBI 0.1-8 RMySQL 0.5-5 Both of DBI and RMySQL packages were downloaded from bell lab: http://stat.bell-labs.com/RS-DBI/download/index.html My case in R is as follows: > library(DBI)

Dear forum, I'm trying to install RMySQL but I'm having problems in loading it, here is the message that I'm getting in R install.packages("RMySQL", dependencies=TRUE) trying URL 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.5/RMySQL_0.6-0.zip' Content type 'application/zip' length 391364 bytes opened URL downloaded 382Kb package 'RMySQL'

i was able to install DBI and RMySQL cleanly. I get the error below on "library('RMySQL')". The file it is complaining about is located in /usr/lib/mysql/, where is R trying to load it from? Tried a symlink into /usr/local/lib/mysql to no avail. thx. -P Loading required package: DBI Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared