BUG in RODBC with OS X?

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.