similar to: RODBC package to connect to Oracle database Linux

Carlos, al parecer tengo instalado el paquete RODBC en : /home/luisr/R/i686-pc-linux-gnu-library/3.0/RODBC/ no hay nada en (carpeta vacia): /usr/local/lib/R/site-library/ en el directorio: /usr/local/lib/R/site-library hay paquetes que vienen con R pero RODBC no saludos, Luis -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- Luis Ridao Cruz Faroe Marine Research Institute Nóatún 1,

Hola, ¿qué tal? ¿Puedes comparar la salida del comando Sys.getenv("LD_LIBRARY_PATH") en una sesión en la que funciona RODBC y otra en la que obtienes el error anterior? Un saludo, Carlos J. Gil Bellosta http://www.datanalytics.com P.D.: A propósito, también he estado tratando de utilizar RODBC en Linux y me he acabado rindiendo. Sobre todo porque RJDBC funciona bastante bien.

Pues ahí lo tienes. De alguna manera R (a través de RStudio) no está incorporando el directorio /u01/app/luisr/product/11.1.0/client_1/lib donde se ve que tienes las librerías de ODBC al "LD path". Échale un vistazo a https://support.rstudio.com/hc/communities/public/questions/200641818-How-to-configure-libPaths-?locale=en-us Aparentemente RStudio tiene su propio sistema para

No, no estoy usando Rstudio Server El 1 de abril de 2014, 9:07, Carlos J. Gil Bellosta <cgb@datanalytics.com>escribió: > Una pregunta... no estarás utilizando RStudio server, ¿verdad? > > En tal caso, lo que tienes que hacer es configurar > /etc/rstudio/rstudio.conf tal como indica en > > http://www.rstudio.com/ide/docs/server/configuration > > En particular,

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

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

I have the next function : "extracting.lgddata"<-function(channel) { library(RODBC) channel<-odbcDriverConnect("") ....... ....... } ...... is just a sequence of SQL selects. But when I try to call the objects created from the select they do not seem to have been created. I checked with ls() and they actually do not exist. What is the problem? Thank you Luis Ridao

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 =

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

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

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

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

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

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

I am sure I'm doing something wrong here but not sure what. Our system administrator recently installed UnixODBC and the MyODBC driver on a Linux box running Linux version 2.6 x86_64. I have an .odbc.ini file in my home directory with following lines: [mydb] Description = MySQL server on my-server Driver=/usr/lib64/libmyodbc3.so SERVER=my-server I can successfully do the following:

Hola a todos, Tengo un problema con RStudio y la conexión a una base de datos. Desde la terminal no tengo problemas para ejecutar, por ejemplo: library(RODBC) channel <- odbcConnect("MiBaseDatos", uid = "MiUsuario", pwd = "MiContrasena") datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \ , M.STODNR \ ... ... ...") pero desde

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

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 <-

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

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