Displaying 10 results from an estimated 10 matches for "handle_ptr".
2012 Jul 30
1
why querying Sybase IQ using RODBC returns error ?
...sql <- sprintf(sql, ...)
x <- sqlQuery(chan, sql, as.is = as.is)
return(x)
}
R>
R>
R>
R> x <- sybaseiq.query("select * from syagprd1.orders where
tradedate='120727' and acct='DVW'")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize,
:
negative length vectors are not allowed
R> x
[1] "42000 -131 [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'order' on
line 1"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'sel...
2005 Apr 19
2
RODBC odbcCloseAll odbcClose Windows XP
...e error message
for both functions:
odbcCloseAll() produces:
Error in .Call("RODBCCloseAll", PACKAGE = "RODBC") :
"C" function name not in DLL for package 'RODBC'
odbcClose(channel) produces:
Error in .Call("RODBCClose", attr(channel, "handle_ptr"), PACKAGE = "RODBC") :
"C" function name not in DLL for package 'RODBC'
Implementation of the two functions in previous versions of R worked flawlessly.
Thank you,
Jason Fisher
2010 Jan 24
0
Setting the value of max in calls to sqlGetResults
...nding unix ODBC 64 bit package
When issuing a SqlQuery, I get the following error
> library(RODBC)
> channel <- odbcConnect("OraLSH", <user>, <password>)
> sqlQuery(channel,"select sysdate from dual")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,
buffsize, :
negative length vectors are not allowed
> close(channel)
> q()
I know I can replace the call to sqlQuery with calls to its component
functions odbcQuery and sqlGetResults to get the same result (and the same
error)
> library(RODBC)
> channel <- odbcConne...
2010 Jan 24
0
Setting thevalue of max in calls to sqlGetResults
...nding unix ODBC 64 bit package
When issuing a SqlQuery, I get the following error
> library(RODBC)
> channel <- odbcConnect("OraLSH", <user>, <password>)
> sqlQuery(channel,"select sysdate from dual")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,
buffsize, :
negative length vectors are not allowed
> close(channel)
> q()
I know I can replace the call to sqlQuery with calls to its component
functions odbcQuery and sqlGetResults to get the same result (and the same
error)
> library(RODBC)
> channel <- odbcConne...
2008 Dec 18
1
RODBC crashes connecting to Teradata
...,
this is what happens when I try to connect via RODBC:
> library(RODBC)
> conn = odbcConnect("thedsn", uid="theuid", pwd="thepass")
*** caught segfault ***
address (nil), cause 'memory not mapped'
Traceback:
1: .Call(C_RODBCGetInfo, attr(stat, "handle_ptr"))
2: odbcDriverConnect(st, ...)
3: odbcConnect("thedsn", uid = "theuid", pwd = "thepass")
Possible actions:
1: abort (with core dump, if enabled)
2: normal R exit
3: exit R without saving workspace
4: exit R saving workspace
Any idea of what is going on here?...
2012 Jul 04
1
RODBC tables
Dear Sir/Madam,
I am desperately in need of some help. I am trying to access tables from
the oracle database and inserting them into R via a data frame and I keep
getting an error saying that "Error in .Call(C_RODBCFetchRows,
attr(channel, "handle_ptr"), max, buffsize, :
negative length vectors are not allowed".
My connection is fine and my code for this is:
check<-odbcConnect(dsn="********",uid="*********",pwd="******")
There are terms instead of the *'s but I am not sure if I should disclose...
2009 Dec 19
2
Run time error when executing sqlQuery using the 64-bit version of R with 64-bit RODBC package in a Solaris 10 Sparc machine.
...lighted text below is the error I'm getting trying to when
invoking a sqlQuery
> library(RODBC)
> channel <- odbcConnect("OraLSH", <user>, <password>)
> sqlQuery(channel,"select sysdate from dual")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,
buffsize, :
negative length vectors are not allowed
> close(channel)
> q()
Any suggestions are greatly appreciated.
Alexander Chelminsky
Principal
CSC
GBS | p: +1 781 290 1620 | f: +1 781 890 1208 | m: +1 617 650 5453 |
achelminsky at csc.com | www.csc.com
This is a PRIVAT...
2012 Aug 27
1
Querying sqlite through RODBC causes R to crash
...C datasource configured with SQLite3 driver,
# but the same happens with SQLite driver
sqlQuery(con3, "select * from test") # 'test' being any table
*** caught segfault ***
address 0x438, cause 'memory not mapped'
Traceback:
1: .Call(C_RODBCQuery, attr(channel, "handle_ptr"),
as.character(query), as.integer(rows_at_time))
2: odbcQuery(channel, query, rows_at_time)
3: sqlQuery(con3, "select * from test")
Possible actions:
1: abort (with core dump, if enabled)
2: normal R exit
3: exit R without saving workspace
4: exit R saving workspace
Select...
2006 Dec 28
0
RODBC not working when connecting to a Sybase database
What is this error message about and how do I troubleshoot it?
> sqlTables(channel)
Error in .Call("RODBCFetchRows", attr(channel, "handle_ptr"), max, buffsize, :
negative length vectors are not allowed
The channel was created as such
channel <- odbcConnect("Labdata")
I think this is telling me that my odbcConnect command worked
> odbcGetInfo(channel)
DBMS_Name DBMS_Ver
&qu...
2009 Apr 10
0
Wine release 1.1.19
...rnetPriority handling tests.
urlmon: Added IWinInetHttpInfo stub implementation to FtpProtocol object.
urlmon: Added IWinInetHttpInfo support to Binding object.
urlmon: Get rid of ICOM_THIS_MULTI macro.
urlmon.idl: Added PROTOCOLFILTERDATA declaration.
basetsd.h: Added HANDLE_PTR and SHANDLE_PTR typedefs.
urlmon.idl: Use HANDLE_PTR in IInternetProtocolRoot::Start declaration.
urlmon: Register CLSID_DeCompMimeFilter.
urlmon: Added DeCompMimeFilter stub implementation.
urlmon: Added IInternetProtocolSink interface stub implementation to MimeFilter obje...