Displaying 20 results from an estimated 700 matches similar to: "RODBC - connect is failing"
2005 Jun 15
2
Reading Excel files...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
2007 Mar 20
1
odbcConnect - no data source and default driver
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
2005 Oct 29
2
RODBC Error
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
2005 Feb 07
2
RODBC working in Rgui but not Rterm
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:
2005 Feb 22
6
rodbc or unixodbc error
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",
2008 Nov 28
1
RODBC - problems connecting to oracle through linux
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
2009 Jul 15
1
Help with RODBC connection to multiple MS SQL Sever databases
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:
2012 May 04
1
Why does RODBC driver returns garbage from Sybase server on new windows 7 machine?
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)
2010 Feb 26
1
need help to resolve RODBC error
I've installed R-2.9.2 (64 bit), unixODBC-2.2.14-p2 (64 bit) and RODBC_1.2-5 (64 bit) on a 64 bit Redhat Linux server (Red Hat Enterprise Linux Server release 5.4 (Tikanga), x86_64) release 2.6.18-164.2.1.el5. I've tested the ODBC drive via isql and the test was success:
[yzhang@ROracleTest ~]$ isql -v DRTST yzhang test
+---------------------------------------+
| Connected!
2005 May 11
0
RODBC Oracle and VB automation with R(D)COM
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
2010 Apr 02
2
How to save a model in DB and retrieve It
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
2003 Aug 25
1
ODBC Oracle access
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
2005 Jan 15
1
Seeking pointers to help
Noob alert....
I've been through most of the available documentation at a fairly high
level - if I've missed the obvious, just point me in the right
direction.
What I'd like to build:
Windows XP system (actually, I'd prever a *nix but must use Win).
Backend data stored in MySQL db
Front end user interface built using PHP/HTML running on Apache.
User builds a select via the web
2005 Mar 28
0
RODBC and OS X
All,
I'm having a problem connecting to an MS SQL Database via RODBC on OS
X. If I try to connect through the GUI using chan <-
odbcConnect("drewdb", uid="user", pwd ="pwd") it simply crashes R with
the following crash report:
Date/Time: 2005-03-28 12:30:48 -0600
OS Version: 10.3.8 (Build 7U16)
Report Version: 2
Command: R
Path:
2004 Mar 08
3
dsn
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
2003 Jul 09
2
RODBC and Oracle: error "table does not exist"
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
2005 Apr 08
2
BUG in RODBC with OS X?
This is my second posting on this topic, the first recieved no
replies. Has anyone successfully used RODBC on the OS X platform?
I've tested the ODBC drivers I'm using with two other applications and
I've had no problems. I begining to think the problem is with R/RODBC
and not the drivers.
Here are the specifics:
I'm having a problem connecting to an MS SQL Database via RODBC
2005 Jul 07
1
q() ==> Segmentation fault
I created the simple library, attached. When I terminate an R session
where the library has been loaded with q() a segmentation fault is
thrown. Is there any cleaning that I should be doing?
>From R session:
> q()
Segmentation fault
or from shell:
$ R CMD BATCH r.in
/usr/lib/R/bin/BATCH: line 55: 17359 Done ( echo
"invisible(options(echo = TRUE))"; cat ${in};
2010 Feb 11
2
SAS and RODBC
I am using R-2.10.1 binary from CRAN on a WinXP Pro system. I also use SAS v9.2 on the same box. I just started using the SAS ODBC driver that comes with version 9 of SAS. I have been able to set up an ODBC source for SAS datasets using the driver, and then with RODBC I am able to read a sample SAS dataset.
> library(RODBC)
> ch <- odbcConnect('sasodbc', believeNRows=FALSE)
2007 Sep 29
1
RODBC and Oracle
Hi WizaRds,
I'm experiencing a problem connecting to an Oracle 10g database via RODBC
(I'm getting this on Microsoft XP).
The same SQL queries via PL/SQL Developer work just fine, but when I pump the query through sqlQuery in RODBC then I get a data frame back with 0 rows.
I cut the query down alternating between PL/SQL and RODBC until I figured
that it's some kind of row limit or