[R-SIG-Mac] BUG in RODBC with OS X?

Drew Balazs drew.balazs at gmail.com
Fri Apr 8 17:53:07 CEST 2005

This is my second posting on this topic, the first recieved no
replies.  Has anyone successfully used RODBC on the OS X platform? 
I've tested the ODBC drivers I'm using with two other applications and
I've had no problems.  I begining to think the problem is with R/RODBC
and not the drivers.

Here are the specifics:

I'm having a problem connecting to an MS SQL Database via RODBC on OS
X. If I try to connect through the GUI using  chan <-
odbcConnect("drewdb", uid="user", pwd ="pwd") it simply crashes R with
the following crash report:

Date/Time:      2005-03-28 12:30:48 -0600
OS Version:     10.3.8 (Build 7U16)
Report Version: 2

Command: R
Path:    /Applications/R.app/Contents/MacOS/R
Version: 1.01 (1.01)
PID:     507
Thread:  0

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_PROTECTION_FAILURE (0x0002) at 0x000001fc

However, if I try it through an xterm (command line), I get the following:

Warning messages:
1: [RODBC] ERROR: state IM004, code 0, message [iODBC][Driver
Manager]Driver's SQLAllocEnv() failed
2: ODBC connection failed in: odbcDriverConnect(st, case = case,
believeNRows = believeNRows)

I'm reasonably sure the DSN is okay because I can use it to connect to
the DB with other applications.
Any suggestions?


Specific Info:
 Machine Model:        PowerBook5,6
 CPU Type:     PowerPC G4  (1.2)
 Number Of CPUs:       1
 CPU Speed:    1.67 GHz
 L2 Cache (per CPU):   512 KB
 Memory:       2 GB
 Bus Speed:    167 MHz
 System Version:       Mac OS X 10.3.8 (7U16)
 Kernel Version:       Darwin 7.8.0
 Boot Volume:  Macintosh HD

R : Copyright 2004, The R Foundation for Statistical Computing
Version 2.0.1  (2004-11-15), ISBN 3-900051-07-0

More information about the R-SIG-Mac mailing list