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

[Prof Brian Ripley]

On Mon, 11 Apr 2005, Simon Urbanek wrote:

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

He would point out that is an iODBC error message and send you to iODBC 
support.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595