similar to: Problemss compiling RODBC

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

In a mdb table, I have a text field with values of 1, 2, .... When I use rodbc to read it into R, it becomes numeric. Is it a bug or something? Thanks.

Hello, I'am currently experiencing some problems with the odbcCloseAll() and odbcClose() function. I'm trying to connect an R script to a MySQL 5.0 database using RODBC1.1-7 and the MySQL ODBC Driver v.3.51 on a Windows XP Machine. At first everything seems fine. The script connects, reads and writes data but when it comes to odbcCloseAll() it crashes and hangs forever. Unfortunately I

Dear All, I am given a set of files names as: velocity1.txt velocity2.txt and so on. I am sure there must be a way to read them automatically in R. It is really taking me longer to read them than to analyze them. Anybody has a suggestion to help me out with this? Many thanks Lorenzo

Hi. I am trying to get data from mysql database using a couple of queries. I do one query to find out the indexes. Then i need to use these indexes in another query, but i keep getting errors. Here is something: numb <- dbSendQuery(con2, "select distinct(comparison) from table1") count <- fetch(numb, -1) my.matrix <- as.matrix(count) rs <- dbSendQuery(con2, "select

I've defined the function getFunNames <- function(FUN){ if (!is.list(FUN)) fun.names <- paste(deparse(substitute(FUN)), collapse = " ") else fun.names <- unlist(lapply(substitute(FUN)[-1], function(a) paste(a))) fun.names } which gives what I want : > getFunNames(mean) [1] "mean" > getFunNames(ff) [1] "ff" >

I think I asked a similar question 3 years ago to the Splus list and I think the answer was no or noone answered so noone should spend more than 5 minutes on this because it could definitely be a waste of time. My question is whether the function below can be rewritten without a for loop. apply is fine if it can be done that way but i doubt it. I call it a lot and would prefer to not loop.

Compilation of MCMCpack under freebsd 6.2 i386 fails because of the following cryptic error: * Installing *source* package 'MCMCpack' ... checking for C++ compiler default output file name... a.out checking whether the C++ compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we

I have the same problem, trying to cross-compile. I'm running Ubuntu Edgy, kernel 2.6.17-10-generic, on an IBM T60. I downloaded the Makefile from CRAN and ran make CrossCompileBuild with the following error messages (also ran each make one at the time and the problem occurs in make R): ../extra/pcre/libpcre.a(pcre_dfa_exec.o):pcre_dfa_exec.c:(.text+0x1703): undefined reference to

Hello, I was trying to build R from source on Windows XP. I installed software which are mentioned from the follow web page http://www.murdoch-sutherland.com/Rtools/ (Last accessed on Nov. 13th, 2006) . Unfortunately, I got error messages whenever I run 'make all recommended' without modifying 'MkRules' file. I have removed software and reinstalled them several times but I still

Hello list, I would like to cross-compile R packages using R 2.4.0. I am working on Linux Debian and cross-compiled (windows binaries) without problems with older R version. I have used the doc of Yan and Rossini in the contributed section of the R documentation (same version of MinGW...). When I try to cross-compile R (make R), the procedure stopped and returns :

This is R 2.10.1, from Fedora 12 and RODBC 1.3-1 (although 1.3-0 has the same problem) on i686. Originally reported here: https://bugzilla.redhat.com/show_bug.cgi?id=557953 Reproducer and output below: [spot at f12.i386 src]$ R R version 2.10.1 (2009-12-14) Copyright (C) 2009 The R Foundation for Statistical Computing ISBN 3-900051-07-0 R is free software and comes with ABSOLUTELY NO

We're trying to setup 3 PRDM partitions (VMware) across 2 nodes. As long as only one is configured in cluster.conf, there's not problem. As soon as we try to use 2 or more we get issues. It looks the same as bug 636: http://oss.oracle.com/bugzilla/show_bug.cgi?id=636 I posted my cluster.conf and command line results there. I'm including them here in the hopes that someone on this

Hello -- I am trying to compile (linker error, not compiler error) RODBC for R 2.9.2 on AIX 5.3 using gcc. I get the following error: gcc -maix64 -pthread -std=gnu99 -shared -Wl,-brtl -Wl,-G -Wl,-bexpall -Wl,-bnoentry -lc -L/usr/lib -L/usr/X 11R6/lib -L/usr/local/lib -L/opt/freeware/lib -L/opt/freeware/lib64 -o RODBC.so RODBC.o -lodbc -lm -L/usr/l ocal/builddir/lib -lR ld: 0711-738 ERROR: Input

Dear R People: I'm trying to compile R-2.15.0 on a 64 bit Windows machine. However, I'm getting the following error: c:\R64\R-2.15.0\src\gnuwin32>set TMPDIR=c:\temp set TMPDIR=c:\temp c:\R64\R-2.15.0\src\gnuwin32>make all recommended make all recommended make[1]: `MkRules' is up to date. make[4]: Nothing to be done for `svnonly'. installing C headers make[2]: Nothing to

All- Does anyone on the list have experience with building RODBC from source on a Linux box for use with DB2? I am using (all from source): R 2.0.1 unixODBC 2.2.9 RODBC 1.1-3 For example: [jcole]$ R CMD INSTALL RODBC_1.1-3.tar.gz 2> rodbc.log * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether

Hello! I'm trying to install R-patched from source on a Windows 64 bit laptop. I have installed R-tools 2.16 and set up the jpeg, tiff, and libpng files Here is the output: c:\R64\R-patched\src\gnuwin32>make all recommended make all recommended make[1]: `MkRules' is up to date. make[4]: Nothing to be done for `svnonly'. installing C headers make[2]: Nothing to be done for

Hi All, I am adding ip_queue module for snort inline IDS. I am using snort2.4.0 And iptables-1.3.4. Userspace Queuing(queue target) is enabled. It is built-in and not built as a module. The output of /proc/net/ip_queue is shown below: cat /proc/net/ip_queue> Peer PID : 0 Copy mode : 0 Copy range : 0 Queue length : 0 Queue max. length : 1024 IPTABLES 1.3.4 is

[ Disclaimer: Yes, I do know that RODBC is in a state of minor limbo as far as maintenance is concerned. But it is also useful, and used, which is why I hope that someone might apply the small change outlined below. ] The current version in CRAN's devel directories fails to build under R 1.6.1 (beta from Oct 27): chibud:/home/edd/RODBC# R CMD INSTALL . * Installing *source* package

Hi all, I try to install the RODBC to no avail. Where is sql.h and sqltext.h supposed to come from? I don't have such files anywhere on my hdd! After downloading latest RODBC.tar.gz, I do R CMD INSTALL RODBC and get the following: * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C