I've installed R-2.9.2 (64 bit), unixODBC-2.2.14-p2 (64 bit) and RODBC_1.2-5
(64 bit) on a 64 bit Redhat Linux server (Red Hat Enterprise Linux Server
release 5.4 (Tikanga), x86_64) release 2.6.18-164.2.1.el5. I've tested the
ODBC drive via isql and the test was success:
[yzh...@roracletest ~]$ isql -v DRTST yzhang test
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select sysdate from dual;
+--------------------+
| SYSDATE |
+--------------------+
| 2010-02-26 13:57:00|
+--------------------+
SQLRowCount returns -1
1 rows fetched
SQL> quit;
However, when I started up R console on the machine and test the RODBC
connectivity to oracle, I got following error:
[ora...@roracletest R]$ R
R version 2.9.2 (2009-08-24)
Copyright (C) 2009 The R Foundation for Statistical Computing
ISBN 3-900051-07-0
R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.
Natural language support but running in an English locale
R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
> library(RODBC)
> channel <- odbcConnect("DRTST", uid="yzhang", pwd="test")
*** caught segfault ***
address (nil), cause 'unknown'
Traceback:
1: .Call(C_RODBCDriverConnect, as.character(connection), id,
as.integer(believeNRows))
2: odbcDriverConnect(st, ...)
3: odbcConnect("DRTST", uid = "yzhang", pwd = "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
I searched around and haven't found any resolution. Please help.
Thanks.
Yan Zhang
Senior DBA
SDI Health, L.L.C.| www.sdihealth.com<http://www.sdihealth.com>
484-362-2022
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
