Displaying 20 results from an estimated 7000 matches similar to: "please, cant install rodbc into R-project"
2010 Apr 20
1
Problem installing RODBC
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
2012 Aug 27
1
Querying sqlite through RODBC causes R to crash
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
2017 Sep 12
3
Unable to load packages RODBC and RODBCext in R
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 '
2004 Apr 08
1
RODBC on FreeBSD 4.9
Hello. I have found a number of posts/threads on this
subject and remain unsuccessful to determine the
solution. In brief, my situation is:
1. Running FreeBSD 4.9 Stable in x86
2. Installed, and running, R 1.8.1
3. Installed, and running, postgreSQL 7.4.2
4. Installed, and running, unixODBC 2.2.8
5. Failed, repeatedly, to install RODBC. The
following is my error log:
tsunami# R CMD
2012 Apr 18
1
Error installing libraries (eg RODBC) on R-2.15.0 : cannot find 'config.log'
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) :
2017 Sep 12
0
Unable to load packages RODBC and RODBCext in R
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
2008 Dec 18
1
RODBC crashes connecting to Teradata
Hi, I'm trying to connect to a Teradata database via RODBC on a Linux 64
machine (Red Hat Enterprise Linux 5). The ODBC driver is properly
configured and queries sent via unixODBC's isql tool work properly. However,
this is what happens when I try to connect via RODBC:
> library(RODBC)
> conn = odbcConnect("thedsn", uid="theuid", pwd="thepass")
***
2010 Nov 04
2
problem with RODBC installation
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
2003 Apr 01
1
RODBC, freetds, and MS SQL Server
I have a question for RODBC users out there. I have used the package with
good results for some time. However, I have just switched from an OpenLink
proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL
Server 2000 I'm connecting to if it matters). I was/am running them from
unixODBC on a Linux Client. I think I have it set up fine since I can use
"isql"
2010 May 12
1
R 2.11.0 on RHEL5 / 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
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!
2011 Aug 29
2
Problem in writing a R data frame to Excel format using RODBC package
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
2010 Oct 18
1
RODBC Error
Hi Everyone,
I am trying to install RODBC but I get the following error message
Error in library.dynam(lib, package, package.lib) :
shared library 'RODBC' not found
In addition: Warning message:
package 'RODBC' was built under R version 2.12.0
Error: package/namespace load failed for 'RODBC'
I am using R 2.11.0 and I see that the package was built with 2.12.0.
However,
2018 Sep 07
2
Problemas para instalar Librería (RODBC)
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>:*
*
2012 Apr 25
3
RODBC Error Code 202 on Mac OS X 10.6
Hello everybody out there using the RODBC package,
On my linux (unixODBC) and windows machines, I can successfully use the RODBC package to connect to a PostgreSQL databse.
On my Mac Book running Mac OS X 10.6 (Intel 64bit architecture), I get the error "code 202" and message "?????" when I try to establish an connection by using
>con <-
2002 Aug 02
1
R to Oracle via RODBC
Howdy,
I'm trying to use R to access Oracle 8i using the RODBC package On Linux
Red Hat 7.3.
Specs
R version 1.51
Driver: Easysoft ODBC - Oracle driver
Driver Manager: unixODBC
I get the following error when trying to executing RODBC commands. Can
anybody give me pointers as to what I'm missing or doing wrong
> library(RODBC)
> channel <- ("DSNName")
>
2018 Sep 07
3
Problemas para instalar Librería (RODBC)
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:
>
2013 Oct 13
0
RODBC not connecting from my Mac
iODBC appears no longer to come standard with OSX, so I installed unixodbc and set it up following instructions here: http://www.boriel.com/en/2013/01/16/postgresql-odbc-connection-from-mac-os-x/
I connected to my remote database with isql -v mydsn. No problem. Then I tried from R:
> library(RODBC)
> pg <- odbcConnect("mydsn") # waited for a couple of minutes before pressing
2011 Jul 20
1
Problem with RODBC
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)
>
2002 Nov 04
2
Problem Installing RODBC under RedHat 7.3
Hello:
Using Redhat 7.3 and
> version
platform i686-pc-linux-gnu
arch i686
os linux-gnu
system i686, linux-gnu
status
major 1
minor 6.1
year 2002
month 11
day 01
language R
I am trying to install the RODBC package.