[R] Re: [R-SIG-Mac] BUG in RODBC with OS X?
Prof Brian Ripley
ripley at stats.ox.ac.uk
Mon Apr 11 17:56:03 CEST 2005
On Mon, 11 Apr 2005, Simon Urbanek wrote:
> 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
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
More information about the R-SIG-Mac