search for: im002

hi, i am using the RODBC package to read .xls files. now after i installed the package and loaded the library and tried to read a file this is the error i got. >channel<-odbcConnect("D:/rstuff/1.xls") Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows = believeNRows) please help me. regards, vivek

...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) y R x64 2.11.0. ¿Alguien puede ayudarme?...

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 the exact same message, but no one replied...

Hi, I want to import some data from Access and I am using the following codes: testdb <- file.path("c/../db1") channel <- odbcConnect("testdb") sqlFetch(channel,"tbl",colnames = TRUE, rownames = FALSE) It comes out the error message: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: ODBC connection failed in: odbcDriverConnect(st, ...) Anyone can help me sort it out? Many thanks. -- View this message in context: http://www.nabble.com/Import--data-from-Access-tf3...

...ow, 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 found and no default driver specified   I do seem to be able to make a connection if I use:   channel <- odbcDriverConnect("driver=SQL Server; server=Fred")   Here, I haven't specified enough information but am...

...essages: 1: [RODBC] ERROR: Could not SQLDriverConnect 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows = believeNRows) > > channel2 <- odbcDriverConnect(connection="DSN=nfl, UID=postgres, PWD=vladdy79" ) 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(connection = "DSN=nfl, UID=postgres, PWD=xxx") Does anyone have any suggestions? Thanks, Michael Greene

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") : ODBC connection failed > version _ platform...

...mport .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, tabQuote = c("[", "]"), ...) : ODBC connection failed I'm obvio...

...= "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 > Melissa<-sqlFetch(odbcConnectExcel("F:\\Cotton2012\\validation.xlsx&quot...

...et 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/databaseName Doing some googling I foun...

..., 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, code 0, message [Microsoft][ODBC Driver Manager] Invalid connection string attribute3: In odbcDriverConnect(&quot...

...bctest where I get an error. The errors are: iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0001.0928 1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002 1: ODBC_Connect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002 I found that the help, at the link above, specifies to edit two files (odbc.ini and odbcinst.ini) in the /Library/ODBC folder. This folder does not ex...

...library(RODBC) > pg <- odbcConnect("mydsn")  # waited for a couple of minutes before pressing Ctrl-C ^C There were 50 or more warnings (use warnings() to see the first 50) > warnings()[1:2] Warning messages: 1: In odbcDriverConnect("DSN=mydsn") :   [RODBC] ERROR: state IM002, code 1606406032, message [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded 2: In odbcDriverConnect("DSN=mydsn") :   [RODBC] ERROR: state IM002, code 1606406032, message [iODBC][Driver Manager]Data source name not found and no de...

...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 odbcDriverConnect(st, ...) : x [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data x source name not found, and no default driver specified x 2: In odbcDriverConnect(st, ...) : ODBC connection failed x > So I somehow have to set the Driver. But how? I didn't find it out. Ciao, Oliver

...database in my computer and I went to the control panel in order to create a DSN file linked to that database. When I'm in R I tried to coneect to it using the command odbcConnect("testdb") but it doesn't work. I received these messages: Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: ODBC connection failed in: odbcDriverConnect(paste("DSN=", dsn, ";UID=", uid, ";PWD=", pwd, Thanks for your coperation. Regards, Giuseppe Faieta

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

...I have followed HowtoConnectToMicrosoftSQLServerFromRailsOnLinux<http://http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux>as best that I can. TSQL is working, example below. My configs are found below. When I run isql : > isql -v pubs name password [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect Does someone have a correctly running configuration that I can review to correct my own? Thanks!! tsql works : root@vmrailsdev:~# tsql -S remote_server -U name -P password loca...

...have installed the Access Database Engine from the Microsoft website. I get the following errors when I try to connect: > channel <- odbcConnect("K:/UWRRDatabase_9Feb2012") Warning messages: 1: In odbcDriverConnect("DSN=K:/UWRRDatabase_9Feb2012") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect("DSN=K:/UWRRDatabase_9Feb2012") : ODBC connection failed I setting up a ODBC connection in ODBC data sources in the Administrative Tools of Control panel...

...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 = case, believeNRows = believeNRows) > channel = odbcDriverConnect('SERVER=mydsn;DATABASE=my_subdb;UID=myid;...

...y using another command library(RODBC) connection = odbcDriverConnect("driver=ORACLE Server;server=01hw0038336";DSN=vikrant;UID=system;PWD=password) Then I am getting folllowing error. 1: In odbcDriverConnect("driver=ORACLE Server;server=01hw088089") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect("driver=ORACLE Server;server=01hw088089") : ODBC connection failed Any help would be greatly appreciated.. -- View this message in context: http://...