search for: odbcdriverconnect

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 = conn) : [RODBC] ERR...

...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 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] Descr...

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 currently know of service requested in connect descriptor 2: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state 01000, code 0,...

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 is the right syntax. I copy-paste files "odbc.ini" and...

...essfully do the following: library(RODBC) channel <- odbcConnect("mydb") sqlQuery(channel, "show databases") And in general, I have no problems using odbcConnect to connect to the mydb DSN. However, for various reasons I want to make a "DSN-less" connection using odbcDriverConnect. However, everything I've tried generated a "data source not found" message (see below for details) After reading through various documents, I tried doing following. (1) Put an odbcinst.ini file in my home directory with following lines [MySQL] Description = ODBC for MySQL Driver...

...lsx") : odbcConnectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel <- odbcConnectExcel2007("results.xlsx") # this was one of proposals from old R help posts, but it doesn't work for me Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : ODBC connection failed...

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 default driver specified2: In odbcDriverConnect("test.mdb") : [RODBC] ERROR: state 01S00...

Hi there, I am using the RODBC library to connect to an Empress database. I have installed the ODBC data source with the server DNs number and port, and named the source "Trawl". It is the odbcDriverConnect that seems to have the problem, and I suspect one of the settings in my Data Source is wrong, or that my syntax to identify the database is wrong. I have not set CodeSet or ODBC Version. Here are the error messages. 1: In odbcDriverConnect("Trawl") : [RODBC] ERROR: state 08001, code -...

...t;, "A", "C","C") each of which have an id in a table in my db. I need to convert the names to their corresponding ids. I currently have the following code to do it. ### names<-c("A", "B", "A", "C","C") dbConn<-odbcDriverConnect(connection="connection string") #successfully connects nameToID<-function(name, dbConn){ #dbConn : active db connection formed via odbcDriverConnect #name : a char string sqlQuery(dbConn, paste("select id from table where name=...

...hat. I have also found many solutions to this problem for txt files and files in additional formats other than Excel 2007. I can read three Excel 2007 files one at a time with the following example code using R 2.10.0 on a computer running Windows (XP, I think): library(RODBC) channel <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb); DBQ=U:\\test folder\\testA.xlsx; ReadOnly=False") sqlTables(channel) my.data.A <- sqlFetch(channel, "Sheet1") odbcClose(channel) channel <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls,...

...he 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 odbcConnect util and the odbcDriverConnect util. I am able to connect to the database through other non-odbc based database programs from the Mac, so I know it's not a Postgres setting (like no tcp/ip connections or something). > library(RODBC) > channel <- odbcConnect("nfl",uid="postgres", pwd=&qu...

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 driver specified Warning in odbcDriverConnect(st, ...) : ODBC connection failed Do you know what needs to be corrected? I am a beginner in DB. There was a post for th...

...e 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 ("Driver=SQL Server;  Server=Fred; Connection=xx.x.x.xxx Database=mydatabasename;  uid=pmiller; pwd=password;  Trusted_Connection=FALSE;")   When I run this code, I get the following error:   [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not...

...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 [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún controlador predeterminado 2: In odbcDriverConnect(con, ...) : ODBC connection failed Trabajo con Windows 7 (64 bits)...

...gs) > 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 = case, believeNRows = believeNRows) > channel = odbcDriverConnect('SERVER=mydsn;DATABASE=my_subdb;UID=myid;PWD=mypasswd') Warning messages: 1: [RODBC] ERROR: state IM007, code 5768012, message [iODBC][Driver Manager]No data source or driver specified, dialog prohibited 2: ODBC...

R-help, I get the following error message when trying to connect to an Oracle database through R (2.8.1) under Linux (Ubuntu 9.04). > channel<-odbcConnect("magnus",uid="luisr",pwd="juanayzakarias") Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: state IM002, code 0, message [unixODBC][DriverManager]Data source name not found, and no default driver specified 2: In odbcDriverConnect(st, ...) : ODBC connection failed I connect to the Oracle database in the following way: $ sqlplus username/password at myIPaddress/...

...cConnect("MiBaseDatos", uid = "MiUsuario", pwd = "MiContrasena") datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \ , M.STODNR \ ... ... ...") pero desde Rstudio me encuentro siempre con el siguiente error: Warning messages: 1: In odbcDriverConnect("DSN=MiBaseDatos;UID=MiUsuario;PWD=MiContrasena") : [RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver Manager]Can't open lib '/u01/app/luisr/product/11.1.0/client_1/lib/libsqora.so.11.1' : file not found 2: In odbcDriverConnect("DSN=MiBaseDatos;UID=MiUsuario...

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 controlador predeterminado 2: In RODBC::odbcDriverConnect("DSN=ProductionReport.mdb&quo...

...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 the Office package. It gives me the following warning message, which make impossible the importing process through sqlFetch: Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado (Source name not found and no default driver specified) 2: In odbcDriverConnect(con, tabQu...

...otton2012\\validation.xlsx"),sqtable = "Sheet3", + na.strings = "NA", as.is = TRUE) Error in sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"), : first argument is not an open RODBC channel In addition: Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : ODBC connection failed...