similar to: ODBC Oracle access

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

Hello Folks, I do hope this is the correct place to post (and not in R-SIG-DB). I have spent the better part of a day searching for an answer to this question, and have yet to resolve it. I am trying to query an .accdb Access database (with 32-bit Office 2007 currently residing on the machine) with 64-bit R via RODBC. There seem to be some conflicting accounts as to whether or not this is

I haven't been able to find any help on this and am really struggling. I've been using RODBC 1.1-3 and R(D)COM v1.35 for a little over a year successfully with my Access Database, and now im switching to Oracle 9i. I use R 2.0.1 on a Windows XP platform, 1GB ram, 2GHz Intel Processor) When I connect through the Rgui R console, the connection is successful (but through VB the attempt

Hola, Alguno ha usado el paquete RODBC para acceder a una BBDD MySQL desde R en Windows? Qu'e mas tengo que hacer a parte de: 1) Aniadir el Driver de MySQL a la lista de User DSN en Control panel -> Administrative tools -> Data Sources(ODBC) 2) Testear que funciona la conexion 2) Ejecutar: ch <- odbcConnect("mydsn",uid="myui",pwd="mypass") Alguna idea?

Hola, Alguno ha usado el paquete RODBC para acceder a una BBDD MySQL desde R en Windows? Qu'e mas tengo que hacer a parte de: 1) Aniadir el Driver de MySQL a la lista de User DSN en Control panel -> Administrative tools -> Data Sources(ODBC) 2) Testear que funciona la conexion 2) Ejecutar: ch <- odbcConnect("mydsn",uid="myui",pwd="mypass") Alguna idea?

Hello Users: I'm using R version 2.0.1, and having problems with RODBC. Everything works fine when I use Rgui, but when I try to use Rterm and issue the commands library(RODBC) con <- odbcConnect("MySQL", "test") I get the following error: Error in sqlQuery(con, str) : first argument is not an open RODBC channel In addition: Warning messages:

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

All, I was wondering if someone had come across the problem of producing partial regression plots for glm objects in R? When using Splus in the past I have passed glm objects to the plot.gam function. To my knowledge this functionality isn't included in R ( I would be happily corrected here) and if someone had some code floating around to do this it would save me re-inventing wheels etc.

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

All, I'm trying to connect to a remote SAS server using SAS's 9.1 ODBC driver and the RODBC package. I'm running R-2.6.1 on Win XP. I can successfully connect to the database, but no matter which table I query, I get back an empty table with only the column headers. For example: > sqlQuery(con, "select * from PRICES.DB_PRICES") [1] COMMOD_CURVE START_DATE

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend:

Using R 2.1.0, RODBC works very well for me. When I move my application to run for the www-data user under apache I get the message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified I made sure that the .odbc.ini file is in www-data home's directory and it is readable. I also defined its location using the environment variable ODBCINI and verified its

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

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

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

Hi I'm presently trying to connect to Oracle through RODBC / UnixODBC on linux (Red Hat 5). I've successfully connected through the easysoft drivers but the trial license has run out and I'm trying to connect via the default Oracle 11G driver. However I'm getting the following error > library(RODBC) > setwd (paste("/home/oracle/scripts/R")) > channel

Hi, I am trying to query a Sybase database on my new windows 7 machine. I am using native sybase driver "Adaptive server Enterprise" following is example code conn <- sprintf("driver=Adaptive server Enterprise;server=PHKSESMD01;database=smd_live;uid=temp_user;password=temp_pass;port=2301") chan <- odbcDriverConnect(conn) x <- sqlQuery(chan,sql,as.is=as.is)

Hi, I'm trying to establish a connection to a MySQL database, and am using the rodbc package for it. This is in a GNU/Debian Linux box, with the corresponding Debian unstable packages. I can login to my MySQL databases from any shell and directory, so the problem is probably not there. Here's an example of what I'm doing: R> odbcConnect("test",