Trying to get RODBC to work on SUSE Linux Enterprise Server 11 (x86_64)
When I run a quick test script like this
=======================================================
library(RODBC)
odbChannel <- odbcConnect(dsn = "CTPRD03", uid = "*********", pwd = "*******")
odbcGetInfo(odbChannel)
df.test <- sqlQuery(channel = odbChannel, query = "select * from DUAL;")
df.test
close(odbChannel)
========================================================
I get the following results:
========================================================
shiny@narc07shiny1dev>Rscript R_SIMPLE_ODBC_TEST.r
DBMS_Name DBMS_Ver Driver_ODBC_Ver Data_Source_Name
"Oracle" "11.02.0030" "03.52" "CTPRD03"
Driver_Name Driver_Ver ODBC_Ver Server_Name
"SQORA32.DLL" "11.02.0004" "03.52" "CTPRD03"
Error in odbcQuery(channel, query, rows_at_time) :
'Calloc' could not allocate memory (18446744073709551616 of 22816 bytes)
Calls: sqlQuery -> odbcQuery -> .Call
Execution halted
Warning message:
closing unused RODBC handle 1
=========================================================
Isql works fine
=========================================================
shiny@narc07shiny1dev>isql CTPRD03
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from dual;
+------+
| DUMMY|
+------+
| X |
+------+
SQLRowCount returns -1
1 rows fetched
=========================================================
Reinstalled RODBC based on previous suggestion in the mailing list and did not
resolve the issue.
Not sure where to go from here, looking for suggestions?
**********************************************************************
*******************************************************************
IMPORTANT MESSAGE FOR RECIPIENTS IN THE U.S.A.:
This message may constitute an advertisement of a BD group's products or
services or a solicitation of interest in them. If this is such a message and
you would like to opt out of receiving future advertisements or solicitations
from this BD group, please forward this e-mail to optoutbygr...@bd.com.
*******************************************************************
This message (which includes any attachments) is intended only for the
designated recipient(s). It may contain confidential or proprietary
information and may be subject to the attorney-client
privilege or other confidentiality protections. If you are not a designated
recipient, you may not review, use, copy or distribute this message. If you
received this in error, please notify the sender by reply e-mail and delete
this message. Thank you.
*******************************************************************
Corporate Headquarters Mailing Address: BD (Becton, Dickinson and Company) 1
Becton Drive Franklin Lakes, NJ 07417 U.S.A.
[[alternative HTML version deleted]]
_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db
