similar to: RODBC in RAqua

Dear All, I wonder whether anyone has an experience with FAME package written by Jeff Hallman. All my attempts to send him the following problem report did not succeed (the mail system says that my e-mail could not be delivered), so I turn for help to this list. I tried to use your FAME package written for R, but somehow I cannot get it working. I am using Windows XP and the newest R

Hi all, I am attempting to learn SQL through sqldf... One task I am particularly interested in is merging separate (presumably large) files into a single table without loading these files into R as an intermediate step (by loading them into SQLite and merging them there). Taking a step back, I've considered these alternatives: 1) I know if I use straight SQLite commands I might use the

Hi all: I have created a MS Access table named 'PredictedValues' through the statement below: myDB <- odbcConnectAccess("C:/Documents and Settings/Owner/Desktop/Rpond Farming.mdb",uid="admin",pwd="") sqlSave(myDB,PredictedValues,rownames=FALSE) close(myDB) But if I run the code again with new values I get the message below: Error in sqlSave(myDB,

I think I figured this out. I should not have put the Driver name in braces. Changing it from {MySQL} to MySQL seems to work. -----Original Message----- From: Marcus, Jeffrey Sent: Tuesday, January 12, 2010 6:09 PM To: 'r-help at r-project.org' Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux I am sure I'm doing something wrong here but not

Hi - I am something of a newbie and am a little perplexed. When (trying to) modify a table I issue the following commands with subsequent errors sqldf("alter table Korea drop column code", dbname = "mydb") error in statement: near "drop": syntax error or sqldf("alter table Korea rename column hyr to hyrI", dbname = "mydb") error in statement:

I think I have isolated a problem with integration between Sweave and beamer. Could you please see the file: http://www.mayin.org/ajayshah/tmp/bugdemo.Rnw Unfortunately, it uses some of my internal libraries, so you can't run it. When I put it through Sweave, I get: http://www.mayin.org/ajayshah/tmp/bugdemo.tex which is, of course, a generic latex file which you can read and

So, my use case is : 1. lot of connections over dial-up lines 2. need to transfer safely A SINGLE BZIPPED FILE to the server 3. if dial-up line fails, it's automatically restarted after 5 minutes and transfer start again I heard about the --partial option in order to keep the partial transferred file. I thought that rsync will apply his incremental check and update alghoritm on that

Hello using Asterisk 1.8.32. I notice that there is a spontaneous reboot of the Asterisk system from time to time. When I look in the logs (verbose file) I noticed that every time this occurs it's at a moment that there is a MySQL action, be it a lookup or an insert/update/delete. I must say I do have some MySQL queries that occur in my dialplan when a call comes in, to look up

Dear list, I learned how to connect R to a local MySQL server, using: drv <- dbDriver("MySQL") con <- dbConnect(drv, user="root", password="mypass", dbname="mydb") Is it possible to connect R in this way to an external server (on a different machine, with a different IP)? I read the documentation on ?dbConnect (and everything I could find on the

Hi, I just installed ROracle and RDBI. The connection to the database seems to work also. My problem is when I am selection rows that really exist in the database, it is returning nothing. Where should I look to see what could be my problem? Thank you very much, Mathieu > drv <- dbDriver("Oracle") > summary(drv, verbose=TRUE) <OraDriver:(6721)> Driver name:

Hello thank you for your answer. If I read your (and others) reaction correctly I can conclude that this is an Asterisk problem and not a problem of MySQL or dialplan logic ? You should know that the MySQL database is heavily questioned : mysql> show status like '%onn%'; +--------------------------+--------+ | Variable_name            | Value  |

I am a user of a i book G4 with OS X 10.3 and I installed RAqua 1.8.1 without any problems. When I want to start RStart the "R" Symbol appers for one second and then disappers again and nothing else happens. I've tried to reinstall the program and I also reinstalled my OS X wich did not help. I really need this program for my studies. If someone knows whats wrong please eMail

While playing around with panther I discovered (with surprise) that tcltk seems to work (even if not smoothly) with RAqua without first calling tkStartGUI. I switched back to 10.2.6 and it works as well. I think this is due to the "last minute" fix in RAqua now using idle timers because of too much cpu usage. Some "mouse" trick is needed though. If you want to test it you

this is a suggestion for a feature in future releases of RAqua for mac OS X: It would be very nice if the gui conformed to the navigation keys that most other os x apps do (with the exception of ms word and mozilla). i am referring to the use of ctrl- f, b, n, p, e, and a for navigating forward one character, backwards one character, up one line, down one line, to the end of a line, and to the

From the RAqua faq just uploaded to CRAN (so it will take until tomorrow to appear) Panther notes After installing Panther (MacOSX 10.3) it turns out that package installation (either from sources or from binaries) can fail. If you get an error "like" this (this comes from source package installation) dyld: gcc version mismatch for library: /usr/local/lib/libiconv.2.dylib

It seems that RAqua consumes too much cpu time when doing nothing. I can't see exactly why this is happening. We have few days to fix this up. Any idea (after having look at the code) would be fine. stefano

I've built a version of RAqua that uses X11 TclTk and NOT AquaTclTk. http://www.economia.unimi.it/R/RAquaX11.dmg (15 MB disk image) The idea is that you: launch RAqua, launch X application (the X Server), and from inside R type x11() # just tt set DISPLAY to :0.0. Eventually close this window device, we don't need this. load(tcltk) quartz() demo(tkdensity) It works on my Panther

HI: Is it possible to use the RODBC package within MS Access. I have been using from R but was just wondering if it could be used along with R(D)COM. Something like this: Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim myApp As StatConnector Set myApp = New StatConnector myApp.GetErrorText myApp.Init "R" myApp.EvaluateNoReturn "library(RODBC)" myApp.EvaluateNoReturn

Hi, I use RAqua on mac os x 10.3. I am trying to connect to an odbc dsn, but RODBC can't seem to find it. I have it installed in my ODBC Administrator in /Applications/Utilities as a system-wide data source. does RODBC need more than just the dsn name (like a path or something)? I have everything set up identically on a windows box, and all seems to work fine. thanks, peter

I'm just beginning to explore Raqua on a new G5 machine. Generally, it feels very natural, but I'm puzzled by the behavior of editing windows. When you use fix() or vi() or edit() you get a new window; this is fine, but is there a way to: o specify what editor is operating in this window o control the size of the window o allow control to revert back to the R console with the