similar to: sqlSave()

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

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 have found that the "schema.table" syntax used in Postgresql (and Oracle) does not work directly with RODBC. This works library(RODBC) con<-odbcConnect("mydb") d<-sqlQuery(con,"select * from meso.trees") However this does not. d<-sqlFetch(con,"meso.trees") Error in odbcTableExists(channel, sqtable) : ?meso.trees?: table not found on channel

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

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

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  |

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

I wish to use PostgreSQL with PHP+PDO. I haven't use PDO before. I have the php-pdo package installed on my CentOS 4.7 server: # rpm -qa |grep pdo php-pdo-5.1.6-3.el4s1.10 Now when I try connect to the PostgeSQL db with this code: <?php print "PDO test<br />"; try { $db = new PDO("pgsql:host=192.168.0.180;port=5432;dbname=mydb;user=test;password=test");

Good evening, folks. Using the module''s puppet forge to create a database I get an error below. Could you help me? *puppetlabs-mysql (v1.0.0) * *class mysql_default {* * * * mysql::db { ''mydb'':* * user => ''root'',* * password => ''123456'',* * host => ''localhost'',* * grant

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"

Hello R community: I'm encountering unexpected behaviour as I download string data from MySQL using the RODBC package. The unexpected behaviour is that the last character of the string is truncated. As far as I can see, this happens when some strings are of length 501 or more. Here's how to reproduce this behaviour. ## In MySQL, pick a database and run this: CREATE TABLE test ( v1

Hi, I'm trying to use RODBC without having to set up a DSN, using hte direct connection string in odbcDriverConnect. My connection attempt looks something like: > odbcDriverConnect(connection = "SERVER=localhost;DRIVER={/usr/lib/odbc/libmyodbc.so};DATABASE=myDB;UID=reader;PASSWORD=insecure;") And this returns the message: Warning messages: 1: In odbcDriverConnect(connection =

Hi. I frequently use RMySQL package to interface R with MySQL databases. I was having a try with package DBI and I got the following error: > library(RMySQL) > library(DBI) > drv <- dbDriver("MySQL") > ch <- dbConnect(drv, dbname="mydb", user="myuser", password="mypasswd") > ibm <- dbGetQuery(ch,"select * from table where