Hi I've experienced some unpleasant behaviour while attempting to connect to an Empress 8.6.2 RDBMS via RODBC 1.2-3 and a freshly minted R 2.6.2.pat on a SLED linux system where a call to odbcConnect() to initiate the odbc connection causes R 2.6.2.pat to segfault.
The odbcConnect call is CHANNEL <- odbcConnect("myEmpressDB", uid="myusername", pwd="mysecurepassword", believeNRows=FALSE) where "myEmpressDB" is an apparently correctly configured ODBC datasource pointing at the Empress RDBMS I wish to access on my system. The R version data for my system are platform i686-pc-linux-gnu arch i686 os linux-gnu system i686, linux-gnu status Patched major 2 minor 6.2 year 2008 month 03 day 02 svn rev 44661 language R version.string R version 2.6.2 Patched (2008-03-02 r44661) All a bit surprising (to me, at least) as: (i) testing connections to the Empress datasource with isql on my SLED linux system is successful, suggesting to me that the Empress driver and the datasource are correctly configured; (ii) I am able to successfully initiate a connection to a non-Empress odbc datasource (postgres and mysql databases) on my SLED linux system within R and to send and retrieve data from these; and (iii) an analogous setup (R, Empress odbc driver, datasource,...) on a windows XP system that I have access to works flawlessly. Any suggestions about how to proceed? Thanks muchly, Michael _
begin:vcard fn:Michael J. Manning n:Manning;Michael org:National Institute of Water and Atmospheric Research (NIWA);Inshore and Pelagic Fisheries adr:295-301 Evans Bay Parade, Kilbirnie;;Private Bag 14901;Wellington;;;New Zealand email;internet:[EMAIL PROTECTED] title:Scientist tel;work:+64 (0)4 386 0851 tel;fax:+64 (0)4 386 0574 x-mozilla-html:FALSE url:http://www.niwascience.co.nz version:2.1 end:vcard
______________________________________________ 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.