similar to: RODBC patchlet

As most R developers maybe are already aware of, R version 1.2.0 introduced a new `generational' garbage collector which means that strings and vectors (and language objects) are handled differently from the numerical atomic types. >From ``Writing R Extensions'': Earlier code was written in a style like. VECTOR(dimnames)[0] = getAttrib(x, R_NamesSymbol);

Hi All, I'm getting the following error, could anyone help please? $ R CMD INSTALL RODBC_1.1-7.tar.gz * Installing *source* package 'RODBC' ... checking for gcc... gcc -std=gnu99 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

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 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

I have been RTFM/doc/www, but I'm still lost. How does one tell R CMD INSTALL and R CMD check (both) that libraries are installed in non-usual places and so -I/APPS/include (or whatever) is necessary in CPPFLAGS and -L/APPS/lib (similarly) is necessary in LDFLAGS? I know I can hardwire them in pkg/src/Makevars, but this requires hand editing of that file by each installer (yuck!) rgentlem

I have been RTFM/doc/www, but I'm still lost. How does one tell R CMD INSTALL and R CMD check (both) that libraries are installed in non-usual places and so -I/APPS/include (or whatever) is necessary in CPPFLAGS and -L/APPS/lib (similarly) is necessary in LDFLAGS? I know I can hardwire them in pkg/src/Makevars, but this requires hand editing of that file by each installer (yuck!) rgentlem

Our current intention is to no longer include Rversion.h from R.h as from R 1.6.0 (which is months away). Package maintainers when revising code might like to check if they actually use Rversion.h, and if so include it explicitly. I did a quick grep through the CRAN packages, and in all but one case (mda) the test is for R < 1.2.0, so it may be simplest just to tidy up and add `Depends: R

I'm a newcomer - obvioulsly I fear. Tried to install RODBC from CRAN mirror onto mahcine 64bit running suse10. terminal log below - it failed on "ODBC headers sql.h and sqlext.h not found" di i need anothe rpackage?? can someone help please? ta v much Prof R Gott Durham UNiv, UK > install.packages(c("RODBC")) trying URL

Hi, I have tried to disable stack checking by set R_CStackLimit to -1. However, it always crashes my win32 multiple threads program. I am using R-2.5.0. My code looks like: #include <Rversion.h> #if (R_VERSION >= R_Version(2,3,0)) #define R_INTERFACE_PTRS 1 #define CSTACK_DEFNS 1 #include <Rinterface.h> #endif and then, add below line to my main function: R_CStackLimit =

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

My R_version is 2.11.1. I can?t install R packages. The error massages are following: package 'DBI' successfully unpacked and MD5 sums checked error in normalizePath(path) : path[1]="E:\R-2.11.1\library/DBI"?? -- View this message in context: http://r.789695.n4.nabble.com/A-question-of-install-R-packages-tp2327716p2327716.html Sent from the R help mailing list archive at

Hi, I have tried to install.packages("RODBC"), but it balks: Installing source package `RODBC'' ... creating cache ./config.cache checking for library containing SQLTables... no configure: error: no ODBC driver manager found ERROR: Configuration failed for package `RODBC'' What am I missing? What and where should "SQLTables" be? In another package? What

First I tried 'setenv R_SHELL /usr/local/bin/bash', as bash is the weapon of choice for the faculty wishing to use R, then ran ./configure as before. The ./configure output line using as R_SHELL for scripts ... /usr/local/bin/bash would seem to indicate that the R_SHELL environment variable was recognized and acknowledged. However, I got the same build error: gnumake[2]: Entering

I have some questions about the RODBC package. library(RODBC) # required for those who want to repeat these lines 1st, I noticed that the following sequence does not work: channel <- odbcConnextExcel("test.xls") tables <- sqlTables(channel) name1 <- tables[1, "TABLE_NAME"] # this should be the name plan1 <- sqlFetch(channel, name1) # bang!

essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15" ,case="oracle") > sqlTables(essai)$ORESTE ... 1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA> 1316 <NA> ORESTE S_PROVENANCES TABLE <NA> 1317 <NA> ORESTE

Greetings - After 20+ years of using SAS, for a variety of reasons, I'm using [R] for a bunch of things - while I'm getting a pretty good a handling [R] for script programming, and statistical analysis, I'm struggling with 'pulling data into [R]'. For reasons beyond my control, a number of the files I get sent to 'work with' are in Dbase format (*.dbf). For

Dear r-helpers! I have trouble reading data from an Oracle data base using RODBC Version 1.0-3, R Version 1.7.1, Windows XP, Oracle8 ODBC Driver Version 8.1.6.4.0: > library(RODBC) > channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE) > # ok, this was succesful > x <- sqlTables(channel) > x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME

Hello List, I am trying to install RODBC package in a debian linux box but getting the following message. Can anyone help me to find what I am doing wrong here: $ R CMD INSTALL RODBC_1.0-4.tar.gz ### * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output... a.out checking whether the C compiler works... yes checking whether we are cross

Hello: Using Redhat 7.3 and > version platform i686-pc-linux-gnu arch i686 os linux-gnu system i686, linux-gnu status major 1 minor 6.1 year 2002 month 11 day 01 language R I am trying to install the RODBC package.

Hi, I'm attempting to use the RODBC package on Windows Vista to import an excel spreadsheet. The spreadsheet has three worksheets the last of which is blank. Following an example in Phil Spector's book (p. 34), after creating a connection named con I did the following: > con RODBC Connection 3 Details: case=nochange DBQ=c:\temp\test.xls DefaultDir=c:\temp