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:

[yzhang@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:

[oracle@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]]

