similar to: Partial transferred files useless at resume, compare-dir can help ?

I've been trying to get RODBC working in RAqua. For my database, let's call it "mydb", when I enter odbcConnect("mydb") or odbcConnect("mydb", uid="postgres", pwd="secret"), RAqua thinks for about 10 seconds, then crashes. mydb is a PostgreSQL 7.4.2 database running on my machine (Mac OS X 10.3.3). I am using the pgsqlodbc 7.2.5 driver

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

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

I don''t know what has happened because know I can''t even get this guest booting. The guest conf I think is correct: kernel = "/boot/vmlinuz-2.6.18-8.1.4.el5xen" builder=''linux'' memory = 384 name = "ns1" vcpus = 1 #vif = [ ''mac=FE:FF:FF:FF:FF:FF , ip=139.185.48.214, ''bridge=xenbr1'' ] vif = [ '''',

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,

Hi, Should I be able to use the Webrick postamble instead of using .campingrc, to tell Camping I want to use mysql? It doesn''t seem to be working for me. It does work however, when I''m using FastCGI (establish_connection :adapter => ''mysql''). James

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:

Buenas, Alguno usa alguno de los paquetes de Microsoft R para la conexion a SQL Server? De ser asi, que paquete y que comandos usais? Yo hasta ahora he usado odbc, de Rstudio, pero me da siempre problemas con el tipo de datos que tiene SQLServer ... Un saludo Jes?s [[alternative HTML version deleted]]

Hi there! How can i use 2 database connections in my rails application ( if it''s possible of course ): one for reading from DB and one for writing to DB? Thanks, Dmitry -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To

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

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

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 running R version 2.9.2 on Windows XP OS with RODBC version Version: 1.3-0. Has anyone out there in the R user community successfully appended records to a DB2 table on a remote database using the sqlSave function in the RODBC package? (or by any other means from R?) I posed a similar question a few months ago and unfortunately, did not receive a response. I was hoping recent upgrades to

Hello everybody, my name is Francesco, I am an italian student graduating in physics. I'm studing the Theora video codec and making some comparative tests. Unfortunately i'm not able to find some informations that could be useful. If someone could make clear some concepts, (or tell me where i can find these informations), i'll be very happy. ( I've yet read the Theora Format

Dear R community, I tried to optimized my R code by using Rprof. In my R code I'm using MySQL database connections intensively. After a bunch of queries R fails with the following error message: Error in .Call("RS_MySQL_newConnection", drvId, con.params, groups, PACKAGE = .MySQLPkgName) : RS-DBI driver: (could not connect mylogin@mydatabase on dbname "myDB"

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:

Hi. i have an asterisk 11 installation that i run in my soho environment. My system has mysql to store all the cdrs. I would like make use of the mysql and store numbers and names. eg +4922123456789 "Atux Null". So when the +4922123456789 calls in my system the name "Atux Null" will pop up next to the number. at the moment i have a database called MyNames in mysql that has this

Hello everyone! Pushing my new rails project I stumbled upon some weird problem. I cannot force WeBRICK to show me my MySQL records in UTF-8. All I recieve into the object (instead of russian letters) are question marks (a la ?????? style). I am running MySQL 4.1 (the one with switchable charsets) and a binary Ruby extension for it, all on OSX. To me it looks like MySQL never recieves what I