[R] 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?
-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
More information about the R-help
mailing list