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

[Simon Urbanek]

Drew,

On Apr 8, 2005, at 11:53 AM, Drew Balazs wrote:

> This is my second posting on this topic, the first recieved no
> replies.  Has anyone successfully used RODBC on the OS X platform?

Yes - it works pretty much out of the box. I tested it with the  
Actual drivers and they work pretty well (although I don't have any  
MS box to test the MS SQL part of it).

> 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:

Well, you didn't send the crash report, but only a small  
(unfortunately useless) part of it. Given the error below, chances  
are that the error is caused by the driver. As of the GUI, you should  
include the version (and possibly revision) of the GUI along with the  
full report so we can try to track it down. However, this won't help  
with the ODBC problem you have.

> 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

If you think this is not a driver problem, you should consider  
contacting the package maintainer, although I don't give it much hope  
as most ODBC problems are driver-related (and most drivers have very  
little OS X support). Alternatively you could ask on the  iODBC pages.

Cheers,
Simon