search for: odbcconnect

Displaying 20 results from an estimated 239 matches for "odbcconnect".

2005 Jan 07
2
Windows package development: bad html links to functions in non-standard packages
..., 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{ \code{\link[lattice]{xyplot}}, \code{\link[MASS]{rlm}}, \code{\link[RODBC]{odbcConnect}}} I have installed RODBC in a separate library, pointed to by R_LIBS. The HTML links to xyplot and rlm work fine, but those to packages not in the standard library can't be found (such as to odbcConnect above). The link points to a non-existent file in the main library (file:///c:/r/library/...
2006 Jun 09
3
sqlSave() and rownames=TRUE makes my Rgui crash
Hello, I created a table in MySQL with this command CREATE TABLE example (pk INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(pk), id VARCHAR(30),col1 VARCHAR(30),col2 VARCHAR(30)) ### In R, I can connect to this table: library(DBI) library(RODBC) chan <- odbcConnect("MySQL51", uid="root", pwd="xxx") first <- sqlQuery(chan, "select * from example") close(chan) First #[1] pk id col1 col2 #<0 rows> (or 0-length row.names) ### This is the table I'm trying to save: dframe <-data.frame(matrix(1:6,2,3)) co...
2013 Nov 25
0
Fetching data from MySQL via odbcConnect - Error in as.POSIXlt.character(x, tz, ...) :
Hi! I am trying to retrieve data from a MySQL Database using RODBC with the commands odbcConnect and sqlFetch. There are different data files in the database and in some cases it works without any difficulties. Nevertheless I get an error with some data files. Since I'm not familiar with MySQL I hope to get some ideas here. My code looks as follows: myconn <-odbcConnect("database...
2009 Jul 15
1
Help with RODBC connection to multiple MS SQL Sever databases
...[2] "42000 102 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Completed'." When I look at the tables from the contab<-sqlTables(con), it is only getting information from one of the databases. library(RODBC) dwparadigm<-odbcConnect(dsn="dwParadigm", uid = "XXXXX", pwd = "XXXXXX", case = "nochange", believeNRows = TRUE) rptparadigm<-odbcConnect(dsn="Rpt_Paradigm", uid = "XXXXX", pwd = "XXXX", case = "nochange", believeNRows = TRUE) wcrpt<-odb...
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: 1: [RODBC] ERROR: state IM008, code 0, message [MySQL][ODBC 3.51 Driver]...
2003 Feb 14
2
RODBC connection failed
I am trying to restart on R after 2 months stop. Start with previously functioning procedure: "ch<-odbcConnect("dBase Files")" get "Warning message: ODBC connection failed in: odbcConnect("dBase Files") " I have tried unsuccessfully different working directories. The only change I see is that I am working with a new login account on the same machine. Microsoft ODBC is st...
2002 May 10
2
RODBC for importing dbf
...dbf file to R, by saving the data as csv, for instance. However, I have several hundreds of files to do that. So, I thought of using RODBC to read the dbf files and save it as data.frame. However, I cannot even start (this is my first time using such package): > library(RODBC) > bdades <- odbcConnect("prova.DBF") Warning message: ODBC connection failed in: odbcConnect("prova.DBF") > dir(pattern="pr") [1] "prova.DBF" My idea was to use sqlFetch(bdades) to create an R data.frame. I'm using R on Windows. I can open the file prova.DBF with Excel witho...
2010 Sep 16
1
RODBC Access/Excel driver location for 64 bit Win7
...a foggy understanding of the cause of this problem, due to my own ignorance. I hope to use RODBC package to connect to an Access DB when running 64 bit Win7 (R version 2.11.1, 64 bit). I have successfully done this before on a winXP machine. Currently I am unable to establish a connection using odbcConnect("") (I am able to establish a MySQL connection just fine), which I suspect may be a result of the driver setup location varying for 64 bit Win7 and 32 bit Win7. That is, to create a ODBC connection when running 64 bit Win7 the default executable file appears to NOT be the correct c:\wind...
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 Manager]Data source name not found and no default driver specified. Driver could not be loaded 2: ODBC connection failed in: odbcDriverConnect(st, case = ca...
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 would be preferable to cut out the MS access middle-man. The command I'm atte...
2009 May 13
3
SQL Queries from Multiple Servers
I use RODBC as my conduit from R to SQL. It works well when the tables are stored on one channel, e.g., channel <- odbcConnect("data_base_01", uid="....", dsn="....") However, I often need to match tables across multiple databases, e.g., "data_base_01" and "data_base_02". However, odbcConnect() appears limited insofar as you may only query from tables within a single chann...
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
2004 Jun 15
2
S/R/RWeb/ODBC
...grating S+/Statserver applications to R/RWeb as a feasability exercise. I can access databases using ODBC directly in R or S, and using Statserver, but I have not succeeded at extracting into R in RWebs batch mode. I can 'require RODBC' in .Rprofile with apparent success, but the results of odbcConnect differ from those when the command is typed into the R commands window. Instead of a parameter list I get a -1. Does anyone know the solution to this problem? Also, might anyone know the comparative merits of using some PERL module (like DBD::Oracle) to do the extraction, as opposed to using RODBC...
2007 Dec 14
1
RODBC, optimizing memory, "Error: cannot allocate vector of size 522 Kb".
I am using RODBC and "odbcConnect". I have successfully used odbcConnect to extract "modest" amounts of data from SQL. For convenience, (and maybe speed?) I wish, if possible, to extract larger amounts of data in a single query. (I am running R2.6.0 under a machine running Windows Small Business Server with 3...
2010 Dec 17
2
RODBC for 64-bit R with 32-bit Access
...is 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 possible. Ripley's ODBC Connectivity PDF and the odbcConnect docs indicate it is not possible (copied below for reference). However, this thread ( http://r.789695.n4.nabble.com/RODBC-Access-Excel-driver-location-for-64-bit-Win7-td2542550.html) seems to indicate that it may be possible by using c:\windows\sysWOW64\odbcad32.exe: "For 64-bit WIn 7, I need...
2001 Jan 09
3
RODBC Bug?
I'm not sure if this problem is repeatable or particular to my machine. The following works fine - > odbcConnect("demoteam", uid = "demo", pwd = "demo") This causes R to crash - > oracle.info <- list(channel = "demoteam", uid = "demo", pwd = "demo") > demo.db.connect <- function(ora.info = oracle.info) { + channel <- odbcConnect(ora....
2003 Apr 04
2
sqlSave() Question
All, I am new in R. I found sqlSave() doesn't work for our Oracle9i. The following was the message: > sqlSave(channel, USArrests, rownames="state") Error in sqlColumns(channel, tablename) : USArrests : table not found on channel Check case parameter in odbcConnect > sqlQuery() works OK. Please help. Thanks. -MY
2012 Aug 24
1
2 (related) problems with RODBC in 64 bit Windows
...y 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 <- read.csv("~/credentials.csv", head=T, row.names=1) db <- odbcConnect(dsn="DSN", uid=credentials["DSN", "username"], pwd=credentials["DSN", "password"], rows_at_time=1024) on which the odbcConnect call fails with the following error code Error in nchar(uid) : 'nchar()' requires a character vector ( creden...
2006 Sep 19
1
RODBC Connections closed automatically in background
I am having a problem with RODBC's connections. It appears that my connection to the database is closed by R automatically before I am done with it. Here is my code: foo <- function(dsn) { db <- odbcConnect(dsn) odbcSetAutoCommit(db, FALSE) data <- someDatabaseOperation(db) data2 <- someLongCalculation(data) anotherDatabaseOperation(db, data2) # This often fails b/c the db is no longer open. odbcClose(db) } I see some output: Warning: closing unused RODBC handle 9 Warning: [RODBC...
2003 Aug 06
1
RODBC with Windows XP
Hi R-Users, I have very recently switched from using R on windows 2000 to windows XP Professional. With XP I am having problems using the "odbcConnect("")" command. I can use the command perfectly well until I close the database channel with the command "odbcClose(channel)". When I try and re-establish connection following the close command no dialog box appears and an error message is displayed. I am using version 1...