[R] RODBC with RAqua

[Prof Brian Ripley]

On Thu, 11 Dec 2003, Peter McMahan wrote:

> Sorry, I should have been more clear:
> It is a problem with RAqua, because I can connect

DO read the error message, which is from iODBC and not from RAqua and not 
from RODBC.

> using iODBC's `test' function and the command-line
> odbctest.
> When I enter the exact same connection string into R,
> though (odbcConnect("DRIVER=/Library/ODBC/OpenLink SQL
> Server Lite ODBC
> Driver.bundle/Contents/MacOS/sql_st_lt.so;DSN=qa;UID=xxx;PWD=xxx")),
> I get the following error:
> 1: [RODBC] ERROR: state IM004, code -1035222635,
> message [iODBC][Driver Manager]Driver's SQLAllocEnv()
> failed
> Thanks for your help,
> Peter
> 

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