Displaying 20 results from an estimated 1100 matches similar to: "ODBC access"
2002 Mar 07
2
frequency
I'm quite new with R so sorry if I asked something very easy or complicated.
I have a data frame with (for instance) 4 variables (4 columns) and 100 records. I would like to have a 'summary' table for each variable that shows me the following:
variable 1 Freq. % % cumulative
class 1 10 10% 10%
class 2 20 20% 30%
class 3
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
2008 Jul 21
1
RODBC - problems using odbcDriverConnect without DSN
Hi,
I'm trying to use RODBC without having to set up a DSN, using hte
direct connection string in odbcDriverConnect. My connection attempt
looks something like:
> odbcDriverConnect(connection = "SERVER=localhost;DRIVER={/usr/lib/odbc/libmyodbc.so};DATABASE=myDB;UID=reader;PASSWORD=insecure;")
And this returns the message:
Warning messages:
1: In odbcDriverConnect(connection =
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
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
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
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
2013 Apr 15
1
create an access file
Hi there,
I have seen this post.
https://stat.ethz.ch/pipermail/r-help/2007-June/133606.html
have odbc installed in my machine. Now I have the following message:
channel2 <- odbcDriverConnect("test.mdb")Warning messages:1: In
odbcDriverConnect("test.mdb") :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Data source name not found and no
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
2011 Dec 04
3
RODBC connect to Excel (64-bit Windows 7)
Hi to all.
I have a problem to connect to an Excel database using RODBC.
Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following:
library(RODBC)
> channel <- odbcConnectExcel("results.xlsx")
Error in odbcConnectExcel("results.xlsx") :
odbcConnectExcel is only usable with 32-bit Windows # ok this is
clear why it doesn't work
> channel
2010 Sep 26
2
Asterisk ODBC Insert issue
Hi guys,
Having issues with doing an insert statement using ast 1.4.24:
[START]
dsn=mssql-asterisk
write=INSERT INTO testdb (callarrival,callerid) VALUES
('${VAL1}','${VAL2}')
SET(ODBC_START()${TIMESTAMP},${CALLERID(num)})
No errors pop up on execute, but nothing gets inserted.
Read and update work fine,
Wondering where I'm going off track with this,
Thanks,
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
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
2010 Jul 13
2
RODBC and Excel 2010 xlsx
Hi List, just to know if the issue is only a problem of mine or if it is a
general issue due to the new MS Office pack. I'm using R 2.11.1 32 bits in a
Windows 7 x64 with the MS office 2010 x64 installed. I can import .xls files
normally (the same way I did with my Excel 2007 32 bits). But the function
odbcConnectExcel2007 isn't able to import .xlsx files now that I have the
new version of
2013 Jul 16
2
Importing data by odbcConnectExcel in 64 bit
I have probably an old question.
I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC
library does not work. Tried odbcConnectExcel2007 still does not work.
Any ideas.
Thanks
Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),sqtable
= "Sheet3",
+ na.strings = "NA", as.is = TRUE)
Error in
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
2009 Aug 12
1
In odbcDriverConnect ODBC connection failed
R-sig-Debian help,
I have installed an ODBC Driver for Linux.
I want to connect to our database through R via:
>library(RODBC)
>con <- odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS")
Warning message:
In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") :
ODBC connection failed
I don't really know whether this
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
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 <-