[R] RODBC and OS X

[Drew Balazs]

All,

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?

-Drew


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