search for: rodbc

Hello... After installing the precompiled version of R 2.1.0 (congratulations to the R Development Core Team) for Windows XP (Service Pack 2), I'm having problems with the "odbcCloseAll" and "odbcClose" functions within the "RODBC" package. I get pretty much the same error message for both functions: odbcCloseAll() produces: Error in .Call("RODBCCloseAll", PACKAGE = "RODBC") : "C" function name not in DLL for package 'RODBC' odbcClose(channel) produces: Error in .Call(&q...

"R CMD check sos" with R 3.3.0 under Mac OS X 10.11.5 ends as follows: >* checking package dependencies ... ERROR >Package suggested but not available: ?RODBC? > >The suggested packages are required for a complete check. >Checking can be attempted without them by setting the environment >variable _R_CHECK_FORCE_SUGGESTS_ to a false value. Unfortunately, "install.packages('RODBC')" says it's only availa...

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

Hi, Please excuse these questions if they're obvious. I'm new to R. I need to access a Postgres db from R. I'm currently trying RODBC as I spend part of my time on Windows and rdbi.pgsql seems not to support windows at this time. I unzipped the RODBC win binary download into my library directory and tried to load it using library(RODBC) I get the following error: Error in dyn.load(x, as.logical(local), as.logical(now)) : un...

If one attempts to install RODBC (via install.packages('RODBC')) without having an ODBC driver installed, this error message results: checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC'...

Hi everybody, Could I consult one problem? I want to access database with RODBC, first download this package from http://www.microsoft.com/data/odbc as part of MDAC, the version is the newest version 2.7.0. But after I have installed this Package(RODBC) and run command libaray(RODBC), the R system report the fillowing warning information. Error in eval(expr, envir, enc...

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

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

Dear all, Hope you are doing great. I am currently using R version 3.4.1 ("Single Candle") and was trying to install packages RODBC and RODBCext using the following steps: > install.packages("RODBCext") Installing package into ?C:/Users/PaulBernal/Documents/R/win-library/3.4? (as ?lib? is unspecified) also installing the dependency ?RODBC? trying URL ' https://mirrors.dotsrc.org/cran/bin/windows/contrib/3.4/R...

The RODBC installation failed, with the following message ( 2 missing c header files ): checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package ‘RODBC’ * removing ‘/home/hadoop/R/i686-pc-linux-gnu-library/2.15/RODBC’ Warning...

Hello: I am tried to install the RODBC package in debian etch. At the end of the installation it appears errors: ********************************************** * 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...

[ 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/R...

I'm trying to load Affy Annotation data from an Access database into R using RODBC. This has worked fine for quite some time. The bug seems to be correlated to RODBC versions 1.1-7 and later. Works fine: R 2.2.0 with RODBC 1.1-4; R 2.3.0 or R 2.4.1 with RODBC 1.1-6 Fails: R 2.3.1 with RDOBC 1.1-7; R 2.4.1 with RODC 1.1-7 or 1.1-8 Details ===== This works fine: Version 2...

Fedora 10 R 2.8.1 I hope someone can tell me the meaning of error I received trying to install RODBC and how I can get around the problem. n.b. The error originally occurred then I was installing Rcmdr. I then tried to install RODBC separately and received the same error. checking sql.h usability... no checking sql.h presence... no checking for sql.h... no checking sqlext.h usability... no check...

Dear All, I want to connnect R with oracle. I am using RODBC package for this connection. Following is my code to connect library(RODBC) channel <- odbcConnect("Vikrant") I am getting following error. 1: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver for Oracle][Oracle...

I am having a problem with RODBC's connections. It appears that my connection to the database is closed by R automatically before I am done with it. Here is my code: foo <- function(dsn) { db <- odbcConnect(dsn) odbcSetAutoCommit(db, FALSE) data <- someDatabaseOperation(db) data2 <- someLongCalculation(da...

I have working unixODBC (tested isql), but rodbc does not want to install....Ive read the manual how to install rodbc, but I am not linux user so I do not understand well. Can anyone write me the necessary steps? thank you m > install.packages(c("RODBC")) --- Please select a CRAN mirror for use in this session --- Loading Tcl/Tk i...

...; On Jun 20, 2016, at 9:19 AM, Spencer Graves <spencer.graves at prodsyse.com> wrote: > > "R CMD check sos" with R 3.3.0 under Mac OS X 10.11.5 ends as follows: > > > >* checking package dependencies ... ERROR > >Package suggested but not available: ?RODBC? > > > >The suggested packages are required for a complete check. > >Checking can be attempted without them by setting the environment > >variable _R_CHECK_FORCE_SUGGESTS_ to a false value. > > > Unfortunately, "install.packages('RODBC')" s...

Hi Johannes and Dirk: A Divendres 27 Juny 2008 17:05, Johannes Ranke va escriure: > Hi, > > I just added RODBC to the list of packages maintained for the Debian > etch backports on CRAN. The r-cran-rodbc packages are on their way to > CRAN - if you want them now, you can use > > deb http://chem.uft.uni-bremen.de/r-cran etch-cran/ > > as an alternative. Thank you very much!!!! I have i...

Hi all, I would like the following code to work, but it doesn't: library(DBI) library(RODBC) m <- dbDriver("RODBC") # Example for dbConnect(DBI), causes error m <- dbDriver("ODBC") # Example for DBIDriver-class(DBI), causes error The errors are: Error in do.call(as.character(drvName), list(...)) : could not find function "RODBC" (substitute "OD...