search for: believenrows

Displaying 20 results from an estimated 37 matches for "believenrows".

2005 Jun 15
2
Reading Excel files...Error
...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
2009 Jul 15
1
Help with RODBC connection to multiple MS SQL Sever databases
...'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...
2005 Feb 07
2
RODBC working in Rgui but not Rterm
...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.
2005 Feb 01
1
RODBC - connect is failing
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...
2007 Mar 20
1
odbcConnect - no data source and default driver
...='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...
2010 Apr 02
2
How to save a model in DB and retrieve It
...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...
2005 Oct 29
2
RODBC Error
...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...
2005 May 11
0
RODBC Oracle and VB automation with R(D)COM
...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...
2003 Aug 25
1
ODBC Oracle access
...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...
2012 May 04
1
Why does RODBC driver returns garbage from Sybase server on new windows 7 machine?
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)
2005 Feb 22
6
rodbc or unixodbc error
...("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...
2003 Jul 09
2
RODBC and Oracle: error "table does not exist"
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...
2005 Mar 28
0
RODBC and OS X
...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...
2005 Jul 07
1
q() ==> Segmentation fault
...:::::::::::::: 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
2010 Jan 24
0
Setting the value of max in calls to sqlGetResults
...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...
2010 Jan 24
0
Setting thevalue of max in calls to sqlGetResults
...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...
2009 Jul 30
0
RODBC and Oracle
...(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...
2004 Mar 08
3
dsn
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
2010 Feb 11
2
SAS and RODBC
....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...
2008 Nov 28
1
RODBC - problems connecting to oracle through linux
...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...