similar to: RODBC autocommit

I run R 2.0.1 on Debian and connect to Informix database via RODBC. In the table below the column "month" is of type char(1). RODBC seems to be converting this column to boolean if the value is F or T. This is the data in my table: id month year 25 F 2005 26 Z 2005 When I select * for id 25 I get 25 FALSE 2005 When I select * for id 16 I get 26 Z

I created the simple library, attached. When I terminate an R session where the library has been loaded with q() a segmentation fault is thrown. Is there any cleaning that I should be doing? >From R session: > q() Segmentation fault or from shell: $ R CMD BATCH r.in /usr/lib/R/bin/BATCH: line 55: 17359 Done ( echo "invisible(options(echo = TRUE))"; cat ${in};

Till yesterday I was more than satisfied by RODBC, specifically by sqlSave which I had been happily using in a daily crontab R batch job regularly updating a postgresql db for as long as one year. In this R- batch I was able to save records into indexed tables *** even though *** they already existed. in this case sqlSave simply neglected those rows of the input table that were offending the

Apologies if this is already answered elsewhere, but I could not find the answer searching the archives. I am trying to bring my data in from an .xlsx file. The data of interest is an n x m array, but it is preceded with ~2 columns and 30 rows of instrumental "information." An abbreviated example (cols denoted with "," for this example: Subject , 01 wavelength, 400 (30

I wish to query tables that are NOT in the default SQL Server 2012 database. At work I am using SQL Server 2012 and Windows 7. I tested the following on my home set up of Server 2012 and Windows 7. I am using RStudio. I wish to connect to several SQL Server 2012 databases from R. This page helped me get started. http://andersspur.wordpress.com/2013/11/26/connect-r-to-sql-server-2012-and-14/

> r [1] open settle <0 rows> (or 0-length row.names) > class(r) [1] "data.frame" this is an empty data.frame I get back from a sql statement that returns an empty result set. How can I create such an empty data.frame using the data.frame() constructor? I want to have a data.frame with 0 rows but named empty columns. Thanks in advance for any help.

Hello everyone! I'm having the dreaded repeated rows problem in RODBC. Specifically, when I have a NULL value in a column, odbcFetchRows reads the value not as NULL or NA but as the most recent non-NULL value in the column. If there is no such non-NULL column, odbcFetchRows reads the value as 0. Let me give you an example (though you won't be able to run it with the "product"

I have a question for RODBC users out there. I have used the package with good results for some time. However, I have just switched from an OpenLink proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL Server 2000 I'm connecting to if it matters). I was/am running them from unixODBC on a Linux Client. I think I have it set up fine since I can use "isql"

Hi, Version info: R: 1.5.1 RODBC: 0.8.3 Oracle: 8.1.7 unixODBC: 2.2.2 Easysoft ODBC driver: 1.0.0.6 SunOS/Solaris: 5.7 I'm trying to get RODBC working with Oracle on Solaris. I've installed unixODBC and the Easysoft ODBC driver. There are no problems connecting to the DB and executing queries using unixODBC's isql interactive client. Using R and RODBC however, I can open a connection

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 have a large table in Postgresql (result of an MCMC simulation, with 1 million rows) and I would like to retrive colums (correspond to variables) using RODBC. I have a column called "index" which is used to order rows. Unfortunately, sqlQuery can't return all the values from a column at once (RODBC complains about lack of memory). So I am using the following code:

I have searched the archives for using insert into to update spreadsheets using RODBC and have come up short. So, first off, is it possible? I have put together a dummy xls table (c:\foo.xls)for exploring possibilities of RODBC. Ultimately, I am interested in replacing much of our previous use of vba macros with R ( I'd prefer elimination, but will take what I can get ). In order to

I am using R as a data manipulation tool for a SQL database. So in some of my R scripts I use the RODBC package to retreive data, then run analysis, and use the sqlSave function in the RODBC package to store the results in a database. There are two problems I want to avoid, and they are highly related: (1) having R rerun analysis which has already been done and saved into output database table,

Hi, I am hoping to use the RODBC package to write a dataframe to an Excel .xlsx file. The dataframe contains at least one field with character elements that exceed 255 bytes, which appears to be the cell width limit in Excel. Below is example code and the warning message received: library(RODBC) d <-

1. Can I avoid having RODBC use so much memory (35 times the data size or more) making a data.frame & then .rda file via. sqlQuery/save? 2. If not, is there some more appropriate way from w/in R to pull large data sets (2-5GB) into .rda files from sql? [R] reducing RODBC odbcQuery memory use? From: WILLIE, JILL <JILWIL_at_SAFECO.com> Date: Thu 25 Jan 2007 - 22:27:02 GMT

New to R, sorry if one or either of these is an inappropriate list for a question like this below; please let me know if this is a general help question. Jill Willie Open Seas Safeco Insurance jilwil at safeco.com -----Original Message----- From: WILLIE, JILL Sent: Thursday, January 25, 2007 2:27 PM To: r-help at stat.math.ethz.ch Subject: reducing RODBC odbcQuery memory use? Basic

Hi I am running R2.15.2 64-bit on Windows 7, using RODBC 1.3-6, MySQL5.5.20, MySQL Connector 5.5.2 - these are the latest 64-bit versions AFAIK. sqlQuery and sqlSave work fin as expected, but in a long session with a few sqlSave() calls, I get an error, for example: Error in sqlSave(channel = channel, dat = USArrests[, 1, drop = FALSE], : HY000 1461 [MySQL][ODBC 5.2(w)

Hi WizaRds, I'm experiencing a problem connecting to an Oracle 10g database via RODBC (I'm getting this on Microsoft XP). The same SQL queries via PL/SQL Developer work just fine, but when I pump the query through sqlQuery in RODBC then I get a data frame back with 0 rows. I cut the query down alternating between PL/SQL and RODBC until I figured that it's some kind of row limit or

Hey everyone, I don't have a question. Instead some helpful advice with things I've learned from trying to connect 'R' to databases using RODBC. ROBDC is a very handy tool that, once you have everything fixed up nicely, is a great way to have scripts run fairly autonomously, safe in the knowledge that data isn't accidentally messed up. But I was fairly ignorant

I built R 2.2.0 from source on my debian machine yesterday and updated all packages. My problem is that "dates" function from its, that my code heavely uses is now masked by "dates" from chron. How can I specify tehat I want to use dates from its or how can I prevent it from being masked? > library(its) Loading required package: Hmisc Hmisc library by Frank E Harrell Jr