Re: [Iodbc-macosx] iODBC and R

[Tim H. <th...@op...>]

Anthony Darrouzet-Nardi <an...@da...> writes:

> I'm trying to connect to a PostgreSQL 7.4.2 database via ODBC in the
> statistical program "R." My connection attempts return the following
> error from iODBC running on Mac OS 10.3.3. I am using the pgsqlodbc
> driver.

Apart from the R part, I have 10.3.3 and pgsqlodbc here, and it connects to
postgresql 7.4.2, so we can be optimistic so far. 

> ERROR: state IM004, code -1035222635, message [iODBC][Driver
> Manager]Driver's SQLAllocEnv() failed
>
> I looked on the R mailing lists, and the guy who wrote the package that
> makes ODBC connections in R said it was not his problem, so go look
> somewhere else. Perhaps someone here knows where to direct me?

Some obvious questions: what version of iODBC are you using, from where?
(One of our prebuilt packages, or compiled yourself from source/cvs?) Can
you make a connection with (i)odbctest to the same DSN without error?

~Tim
-- 
Product Development Consultant
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: <http://www.openlinksw.com>
Universal Data Access & Data Integration Technology Providers