[R] RODBC and OS X

From: Drew Balazs <drew.balazs_at_gmail.com>
Date: Tue 29 Mar 2005 - 04:32:19 EST


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

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Mar 29 04:46:01 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:56 EST