search for: believenrows

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

...'Completed'." When I look at the tables from the contab<-sqlTables(con), it is only getting information from one of the databases. library(RODBC) dwparadigm<-odbcConnect(dsn="dwParadigm", uid = "XXXXX", pwd = "XXXXXX", case = "nochange", believeNRows = TRUE) rptparadigm<-odbcConnect(dsn="Rpt_Paradigm", uid = "XXXXX", pwd = "XXXX", case = "nochange", believeNRows = TRUE) wcrpt<-odbcConnect(dsn="WC_Reporting", uid = "XXXXX", pwd = "XXXXX", case = "nochange", bel...

...ion: Warning messages: 1: [RODBC] ERROR: state IM008, code 0, message [MySQL][ODBC 3.51 Driver]Invalid window handle for connection completion argument. 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows = believeNRows) Does anybody know how I can fix this problem? Thanks, Shlomo.

I get the following errors when attempting an ODBC connection to a MySQL db. 1: [RODBC] ERROR: state HY000, Code 0, message [MySQL] [ODBC 3.51 Driver] Could not determine the driver name so could not lookup setup library. 2: ODBCConnection failed in: odbcDriverConnect(st, case=case, believeNRows=believeNRows). Win XP sp2 MySQL 4.1.8 My SQLODBC 3.51.10 Package RODBC (latest) is installed. LibMySQL.dll is in about a 1/2 dozen directories including Winnt\System32, my PHP directory, and several MySQL directories. I note that there are apparently different versions of this file (different fil...

...='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 connection failed in: odbcDriv...

...ctly, # in DB I have the "modX" variable # Problem arise retrieving data and 64kb limit: strQ <- " SELECT CONVERT(varchar(max), tModel) AS tModel FROM GRT.GeneratorsModels WHERE (cGeneratorID = 1) " x <- sqlQuery(Channel, strQ, stringsAsFactors = F, believeNRows = FALSE) x <- sqlQuery(Channel, strQ, stringsAsFactors = F, believeNRows = FALSE) #read error Above code is working for simplier models that have a shorter representation in variable "modX". Any advice on how to store and retieve this kind of objects? Thanks Daniele ORS Srl Via A...

...setting (like no tcp/ip connections or something). > library(RODBC) > channel <- odbcConnect("nfl",uid="postgres", pwd="xxx") Warning messages: 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 loa...

...n see that the value is -1, which occurs when a connection fails: >channel<-dget("c:/channel.Rdata") >channel [1] -1 I have identified the problem to the a piece of code trying to establish the connection (residing in the odbcConnect function): odbcDriverConnect(st, case = case, believeNRows = believeNRows) Where st has the value "DSN=MY_DB;UID=MYUID;PWD=MYPWD", and this I believe is the case in both instances since I tried to replicate the odbcConnect code manually in VB, and the two connection strings checked out. It seems to boil down to the following code in odbcDriverC...

...d through to the oracle database in question and that seems to work OK but it would be preferable to cut out the MS access middle-man. The command I'm attempting to use is: conn<- odbcConnect(dsn='myDSN', uid = "myUID", pwd = "myPWD", case = "oracle",believeNRows=FALSE) I wouldn't be surprised if there is an issue with the dsn configuration and not R (though I cant find it) so any tips as to things that I should check there would also be gratefully received. Version _ platform i386-pc-mingw32 arch i386 os mingw32...

Hi, I am trying to query a Sybase database on my new windows 7 machine. I am using native sybase driver "Adaptive server Enterprise" following is example code conn <- sprintf("driver=Adaptive server Enterprise;server=PHKSESMD01;database=smd_live;uid=temp_user;password=temp_pass;port=2301") chan <- odbcDriverConnect(conn) x <- sqlQuery(chan,sql,as.is=as.is)

...("test", uid="myusername", pwd="mypassword") [1] -1 Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows = believeNRows) The error is apparently from unixodbc, and googling for it I found that somebody solved it by specifying a default driver in a odbc.ini file. Can somebody please tell whether this is the right approach, and if so, how to write that specification? I saw that one might do this in a...

Dear r-helpers! I have trouble reading data from an Oracle data base using RODBC Version 1.0-3, R Version 1.7.1, Windows XP, Oracle8 ODBC Driver Version 8.1.6.4.0: > library(RODBC) > channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE) > # ok, this was succesful > x <- sqlTables(channel) > x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 37 <NA> TKF ABTGRNAMEN TABLE <NA> > # ok, so the table I am looking for ("ABTGRNAMEN") is there, but: > sqlF...

...ON_FAILURE (0x0002) at 0x000001fc However, if I try it through an xterm (command line), I get the following: Warning messages: 1: [RODBC] ERROR: state IM004, code 0, message [iODBC][Driver Manager]Driver's SQLAllocEnv() failed 2: ODBC connection failed in: odbcDriverConnect(st, case = case, believeNRows = believeNRows) I'm reasonably sure the DSN is okay because I can use it to connect to the DB with other applications. Any suggestions? -Drew Specific Info: Machine Model: PowerBook5,6 CPU Type: PowerPC G4 (1.2) Number Of CPUs: 1 CPU Speed: 1.67 GHz L2 Cache (per CPU): 512 KB M...

...:::::::::::::: R/zzz.R :::::::::::::: .First.lib <- function (which.lib.loc, package, ...) { library(RODBC) connect() } .Last.lib <- function (libpath, ...) { } :::::::::::::: R/db.R :::::::::::::: connect <- function() { conn <<- odbcConnect('tmc', believeNRows = FALSE) } :::::::::::::: data/data.r :::::::::::::: conn <- NULL

...the same error) > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > odbcQuery (channel, "select sysdate from dual") > sqlGetResults(channel, as.is=FALSE, errors=FALSE, max=0, buffsize=1, nullstring=NA, na.strings="NA", believeNRows=TRUE, dec=getOption("dec")) Which returns the same error, namely: Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed > However, if I modify the value of max=0 (which means there is no limit to the number...

...the same error) > library(RODBC) > channel <- odbcConnect("OraLSH", <user>, <password>) > odbcQuery (channel, "select sysdate from dual") > sqlGetResults(channel, as.is=FALSE, errors=FALSE, max=0, buffsize=1, nullstring=NA, na.strings="NA", believeNRows=TRUE, dec=getOption("dec")) Which returns the same error, namely: Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed > However, if I modify the value of max=0 (which means there is no limit to the number...

...(txn.seq_no = mcc.seq_no) inner join mdd_tmzipfvs tmzip on (txn.seq_no = tmzip.seq_no) where is_test = '%d' and is_pos = '%d' and ora_hash(txn.seq_no,%d,%d)=0" dbConn = odbcConnect("mysid",uid="myuser",pwd="mypass",case="toupper",believeNRows=FALSE) tfg = sqlQuery(dbConn, sprintf(sqlTxnFvs,0,0,1/sratg-1,seeds[i])) dbErr = odbcGetErrMsg(dbConn) All of the tables except mddsg100bp are IOT tables (index organized tables aka clustered index in MSSQL). I set the believeNRows=FALSE. I tried increasing the ODBC DSN config buffer from the de...

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

....2 on the same box. I just started using the SAS ODBC driver that comes with version 9 of SAS. I have been able to set up an ODBC source for SAS datasets using the driver, and then with RODBC I am able to read a sample SAS dataset. > library(RODBC) > ch <- odbcConnect('sasodbc', believeNRows=FALSE) > df <- sqlQuery(ch, 'select * from sasodbc.class', as.is=TRUE) > df Name Sex Age Height Weight 1 Alfred M 14 69.0 112.5 2 Alice F 13 56.5 84.0 3 Barbara F 13 65.3 98.0 4 Carol F 14 62.8 102.5 5 Henry M 14 63.5 102.5 6 Jam...

...ste("/home/oracle/scripts/R")) > channel <- odbcConnect("test", uid="prod", pwd="passwd") *** caught segfault *** address (nil), cause 'memory not mapped' Traceback: 1: .Call(C_RODBCDriverConnect, as.character(connection), id, as.integer(believeNRows)) 2: odbcDriverConnect(st, ...) 3: odbcConnect("test", uid = "prod", pwd = "passwd") aborting ... The below shows the changes in the odbcinst.ini file. [ORACLE] Description = Easysoft ODBC Oracle Driver #Driver = /usr/local/easysoft/oracle/li...