Displaying 20 results from an estimated 3000 matches similar to: "Reading Excel files...Error"
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
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
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
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",
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 01
1
RODBC - connect is failing
I get the following errors when attempting an ODBC connection to a MySQL db.
1: [RODBC] ERROR: state HY000, Code 0, message [MySQL] [ODBC 3.51
Driver] Could not determine the driver name so could not lookup setup
library.
2: ODBCConnection failed in: odbcDriverConnect(st, case=case,
believeNRows=believeNRows).
Win XP sp2
MySQL 4.1.8
My SQLODBC 3.51.10
Package RODBC (latest) is installed.
2009 Oct 23
2
connecting to Oracle
Hi, useR-
I am connecting to Oracle database using RODBC, but keep getting this error
message:
> library(RODBC)
> channel <- odbcConnect(dsn="abc", uid="abc", pwd="abc", case='oracle')
Warning in odbcDriverConnect(st, ...) :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Data source name not found and no default
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
2010 Mar 25
3
Reading SQL Server Tables using RODBC
Hello Everyone,
I'm still quite new to R and am having trouble reading SQL Server Tables using RODBC. I've looked though the RODBC documentation as well as material I found online and in the book "Data Manipulation with R," but I just can't quite seem to get things to work.
Right now, I have code that looks something like:
channel <- odbcDriverConnect
2017 Aug 31
2
Conectar Access con R
Buenas,
Estoy usando R para conectarlo con ACCESS pero me da error:
> conexion<-odbcConnect("ProductionReport.mdb")
Warning messages:
1: In RODBC::odbcDriverConnect("DSN=ProductionReport.mdb") :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún
2007 May 31
2
Import data from Access
Hi, I want to import some data from Access and I am using the following
codes:
testdb <- file.path("c/../db1")
channel <- odbcConnect("testdb")
sqlFetch(channel,"tbl",colnames = TRUE, rownames = FALSE)
It comes out the error message:
1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Data source name not found and no default
2010 Jul 14
2
Error while connecting to Oracle using RODBC package
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]ORA-12514: TNS:listener does not
2010 Jul 15
6
Error cargar datos ACCESS
Hola a todos,
estoy intentendo cargar unos datos contenidos en una tabla de ACCESS, por lo que ejecuto los siguientes comandos
dir<-"C:/Users/D/Desktop/"
library(RODBC)
cn<-odbcConnectAccess(paste(dir1,"datos.mdb",sep=""))
pero me da el siguiente error
Warning messages:
1: In odbcDriverConnect(con, ...) :
[RODBC] ERROR: state IM002, code 0, message
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 Jan 12
1
FW: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux
I think I figured this out. I should not have put the Driver name in
braces. Changing it from {MySQL} to MySQL seems to work.
-----Original Message-----
From: Marcus, Jeffrey
Sent: Tuesday, January 12, 2010 6:09 PM
To: 'r-help at r-project.org'
Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC
package) on Linux
I am sure I'm doing something wrong here but not
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 Oct 04
6
Animation of Mandelbrot Set
Hi,
I was playing with Mandelbrot sets and come up with the following code, I
thought I would share:
library(fields) # for tim.colors
library(caTools) # for write.gif
m = 400 # grid size
C = complex( real=rep(seq(-1.8,0.6, length.out=m), each=m ),
imag=rep(seq(-1.2,1.2, length.out=m), m ) )
C = matrix(C,m,m)
Z = 0
X = array(0, c(m,m,20))
for (k in 1:20) {
Z =
2009 Aug 28
2
RODBC: how to set the data-source?
Hello,
I want to try to connect R to PostgreSQL.
I have found that there are three ways:
DBI or RODBC or RPostgreSQL.
I tried around with DBI and RODBC but didn't get it running.
In both cases I'm not clear about how to set the driver/data source.
I get this error:
x > channel <- odbcConnect("rtest", uid="oliver")
x Warning messages:
x 1: In
2012 Mar 28
1
Get data from Access 2010 database
Hello,
I'm new to R and am trying to access data from a Microsoft Access 2010
database. I've read through the RODBC package vignette and seem to
understand the instructions of the commands but can't see to connect to the
database. I have installed the Access Database Engine from the Microsoft
website. I get the following errors when I try to connect:
> channel <-
2003 Aug 25
1
ODBC access
Hello everybody,
I have tried to connect to external databases (specifically, to a MS Access database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me?
I have a MS Access database in my computer and I went to the control panel in order to create a DSN file