similar to: RODBC working in Rgui but not Rterm

Hello, I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to connect to a PostgreSQL server on the local network. I can't tell whether my problem is in R, or in ODBC setup. I got drivers from OpenLink, created a dsn and tested it using the iODBC application. then I load the RODBC package, use this code and get the following error. I tried with both the

Hi. I recently upgraded to R version 2.4.0, and I have found that the "debug" package no longer works. In particular, when I try to debug a function, I get the following error message: Error in attr(value, "row.names") <- rlabs : row names must be 'character' or 'integer', not 'double' I have, of course, taken all the necessary preceding

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connection so that I can implement it in my sql query below. I'm currently getting the following error:

hi, i am using the RODBC package to read .xls files. now after i installed the package and loaded the library and tried to read a file this is the error i got. >channel<-odbcConnect("D:/rstuff/1.xls") Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: ODBC connection failed

Hi all, I'm having trouble connecting to an oracle database using RODBC under winXP. Unfortunately I can't really send a reproducable error as the initial call to odbcConnect seems to hangs R and I have to kill the session. I have been using RODBC to sucessfully connect to an MS Access DB that has tables linked through to the oracle database in question and that seems to work OK but it

Greetings, I am trying to run a short script from a shell: c:\projects\hell>Rscript --default-packages=mypack X:/4Stephen/commit/curve.R > X:/4Stephen/commit/run1.out Loading required package: utils Warning message: package 'RODBC' was built under R version 2.12.2 Error: could not find function "normalize" Execution halted Warning message: closing unused RODBC handle 1

Hi, I have a data base in oracle and need to link R using ODBC. When i use the command odbcConnect a dsn is needed. I would like to create a dsn.Do you know how can i do it? Thank you. Margarida,Portugal

I am trying to connect sybase sql databast from R using RODBC pkg and getting the following error ( i chnaged names to my*** but when I actually execute it, I put down names explicitly not calling some character strings) > channel = odbcConnect(dsn='mydsn',uid='myid',pwd='mypasswd') Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver

Dear developers, I have come across a (somewhat strange) change in the encoding of Sweave output from R-2.9.2pat to R-2.10.0beta (apparently specific to Rgui) on Windows installations. Of course, the NEWS file contains quite a few changes concerning encoding, but I was not able to locate an entry which explains the observed behaviour. I am not very familiar with encodings/locales/codepages,

Hello. I am trying to build R on Windows. It appears that my build passes the various "make checks" (unless I missed some error) and running Rterm seems to work fine whereas Rgui has an immediate error stating " AppName: rgui.exe AppVer: 2.150.58871.0 ModName: rzlib.dll ModVer: 0.0.0.0 Offset: 0000a9e5 The taskbar still works, but the console window has nothing in it, and

I am using R 2.0.1 Patched on Windows 2000. I have created a binary package for Windows that builds, checks, installs and works without errors. In some of my .Rd files, I have links to functions in the standard packages supplied with R as well as links to others in add-on packages that I have installed. For instance, one .Rd file has the following snippet: \seealso{

I'm wondering how to save an object (models like lm, loess, etc) in a DB to retrieve and use it afterwards, an example: wind_ms <- abs(rnorm(24*30)*4+8) air_kgm3 <- rnorm(24*30, 0.1)*0.1 + 1.1 wind_dg <- rnorm(24*30) * 360/7 ms <- c(0:25) kw_mm92 <- c(0,0,0,20,94,205,391,645,979,1375,1795,2000,2040) kw_mm92 <- c(kw_mm92, rep(2050, length(ms)-length(kw_mm92))) modelspline

I'm having problems getting RTERM to work via SSH. Whenever it has any type of problem, it abends instead of issuing an error message and returning to the > prompt. Both "server" and client are Windows/2000 Professional at FP4. SSH is via Cygwin on both sides. R is version is 1071. RTERM runs fine when run in a BASH shell on the "server," though it does not prompt

[Environment: Win XP, R 2.10.1] In my Rprofile I have startup code to do various things, intended for when I use the Rgui console. Some of these are causing problems in JGR now that I've installed it. How can I test for R running with Rgui to do some of these things only there? -- Michael Friendly Email: friendly AT yorku DOT ca Professor, Psychology Dept. York University

Dear all, I've just downloaded R.12.0 from CRAN (http://cran.r-project.org/bin/windows/base/release.htm). I am unable to find RGUI.exe as well as Rterm.exe. Conversely to what is explained in readme.R.2.12.0: There are two versions of the R executable in R-2.12.0\bin\i386 (32-bit) or R-2.12.0\bin\x64 (64-bit). I can't find directories i386 or x64 in R-2.12.0\bin -- Renaud Lancelot EDEN

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

minimal reproducible example plot(1,1) identify(1,1) # or locator() now, trying to close the window by clicking on the cross of the upper right corner causes Rgui (and Rterm) to crash. I see the same behaviour on 2 different Windows PC (one with Win 8.1 and one with Win 10). I did not see the problem in linux (see below) WINDOWS ************** > sessionInfo() R version 3.3.0 beta

Hi all, I am encountering an RODBC problem in R 2.15.1 in windows 64 bit which I do not encountered in the same set up in windows 32 bit (the latest binary version of RODBC in both cases from the same depository gotten by install.packages(‘RODBC’), Oracle ODBC client software installed in 64 and 32 bit respectively) 1. The code looks like library(RODBC) credentials <-

Dear all, [I work with a Windows XP Prof. installation, and the 2.0.0 R version] I need to use the aws package, but I have the following error message: > require(aws) Loading required package: aws Error in firstlib(which.lib.loc, package) : couldn't find function "lazyLoad" [1] FALSE I download the .zip file (for Windows) today on the CRAN site, so I think I have

Hi all, I have just installed R 2.13.0 and I am experiencing problems with the terminal, but not the with the GUI interface. I am Windows 7. When running "R" or "Rterm" from a commandline I receive the following: Warning message: In normalizePath(path.expand(path), winslash, mustWork) : path[3]="C:/Programmer/R/R-2.13.0/library": Adgang n?gtet R version 2.13.0