similar to: RODBC Error

Hi, Here im not able to connect with MS-SQLSERVER database with *.R-File. Previously i was able to do in R in different machine and configuration was R Ver-2.11.1 Package Installed : RODBC_1.3-2 And now where im doinig now there the same code im trying to execute but its not connecting. configuration is, R Ver-2.12 Package Installed : RODBC_1.3-2 - here iam trying to install (RODBC_1.3-6) which

Good morning, I have some problems installing RODBC to R in a linux cluster. My R version is: R version 2.12.0 (2010-10-15) Platform: x86_64-unknown-linux-gnu (64-bit) I get the following error: > install.packages('RODBC') Installing package(s) into '/home/jorgehou/R/x86_64-unknown-linux-gnu-library/2.12' (as 'lib' is unspecified) trying URL

Dear R-SIG-Debian, while trying to query data from an SQLite database through RODBC on Debian testing, R crashes with the following message: library(RODBC) con3 <- odbcConnect("test3") # 'test3' being an ODBC datasource configured with SQLite3 driver, # but the same happens with SQLite driver sqlQuery(con3, "select * from test") # 'test' being any table

Dear all, Hope you are doing great. I am currently using R version 3.4.1 ("Single Candle") and was trying to install packages RODBC and RODBCext using the following steps: > install.packages("RODBCext") Installing package into ?C:/Users/PaulBernal/Documents/R/win-library/3.4? (as ?lib? is unspecified) also installing the dependency ?RODBC? trying URL '

Hola, Puede ser que la RODBC no corra en la versión 3.3.1? Abajo copio el error. Sabe alguien que puede estar pasando? *Warning in install.packages :* * package ?RODBC? is not available (for R version 3.3.1)* *Warning in install.packages :* * unable to access index for repository https://cran.rstudio.com/bin/windows/contrib/3.3 <https://cran.rstudio.com/bin/windows/contrib/3.3>:* *

Hi Experts, I was trying to write a data frame which has a header row, from R to Excel disk file using RODBC ( RODBC_1.3-1) package. I met with an issue:- If in sqlSave(), I set a parameter "colnames=FALSE" then I get first row as header in excel file. If 'colnames=TRUE' then it gives me first 2 rows as header in excel file. Actually, according to my

I don't use Windows, but this looks like a Windows permissions issue, no? You could try moving them yourself manually or create another library directory that R can access to put them in. ... or wait and hope for advice from someone who uses Windows to give you a definitive answer. Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and

I have working unixODBC (tested isql), but rodbc does not want to install....Ive read the manual how to install rodbc, but I am not linux user so I do not understand well. Can anyone write me the necessary steps? thank you m > install.packages(c("RODBC")) --- Please select a CRAN mirror for use in this session --- Loading Tcl/Tk interface ... done trying URL

Dear list, as I started installing R-2.15.0 on a Red Hat 4.5.1-4 as well a Ubuntu 10.04.3 systems. While the basic installation went fine (like the previous R-2.14.2), now I'm having trouble installing almost one third of the additional libraries I want (which installed flawlessly with R-2.14.2), among them RODBC for which I show the message below (obtained on Ubuntu) :

Hola, Tengo la versión 3.5.1 instalada y no me dejaba tampoco, por eso desde RStudio configuré la 3.3.1. Muchas gracias. El 7 de septiembre de 2018, 13:35, Carlos Ortega <cof en qualityexcellence.es> escribió: > Hola, > > R ya está en la versión 3.5.1 y tú tienes la 3.3.1. > Las versiones antiguas de los paquetes están: > > - Linux: >

I have a problem with some missing headers when trying to install RODBC on my linux box. > install.packages("RODBC", + lib="/usr/local/david/R") trying URL 'http://cran.stat.auckland.ac.nz/src/contrib/RODBC_1.3-1.tar.gz' Content type 'application/x-gzip' length 990220 bytes (967 Kb) opened URL

Dear all, I'm trying to connect to an MSAccess database (ArcGIS personal geodatabase). I keep getting an error about the channel when using sqlQuery(). However, sqlTables() does not complain about the channel and lists all tables in the database. If I try sqlFetch(), then R crashes. I'm happy to hear suggestions on how to solve this. Best regards, Thierry > MDB <-

Dear all, I've used RODBC a lot to read in files created in MS excel and access but found a strange problem today: a variable in my data file contained both numbers and text; sqlFetch would set text within a row of numbers to NA; but if first 5 or 6 rows would be text then all numbers would be read in as NA. con<-odbcConnectExcel("xample.xls") #the file is attached or at

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

Un texte encapsul? et encod? dans un jeu de caract?res inconnu a ?t? nettoy?... Nom : non disponible URL : <https://stat.ethz.ch/pipermail/r-help/attachments/20130214/ca5c528b/attachment.pl>

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

Hi, I am running the RODBC examples form the help guide. I am trying to UPDATE a table in an Access data base but I am having an error. library(RODBC) library(termstrc) path = getwd() setwd(getwd()) dbName = "data.mdb" pathdbname = paste(path,"/",dbName,sep="") accesChannel = odbcConnectAccess(pathdbname, uid = "", pwd = "")

I have been trying to read some data from an Excel workbook without success. The workbook is in .xls format and has multiple sheets, one with the sheet name Data, which is the sheet I wish to read from. One complication is that the header row of this sheet is comprised of dropdown boxes. I tried what I normally would do plus some variations. Here is the output. > require(RODBC) >

I am compiling R 2.11.0 on a RHEL5.3 box using the following settings ./configure --with-readline=yes --enable-R-shlib=yes --with-x=yes --with-blas="-llibptf77blas -lpthread -llibatlas" --prefix=/usr/local/R-2.11.0 JAVA_HOME=$JAVA_HOME CPPFLAGS="-I/usr/local/unixODBC-2.3.0/include" I have compiled and installed unixODBC-2.3.0 (64-bit) in /usr/local and can connect to and

Hi, Please excuse these questions if they're obvious. I'm new to R. I need to access a Postgres db from R. I'm currently trying RODBC as I spend part of my time on Windows and rdbi.pgsql seems not to support windows at this time. I unzipped the RODBC win binary download into my library directory and tried to load it using library(RODBC) I get the following error: Error in