[R] RODBC

[Prof Brian Ripley]

On Mon, 1 Mar 2004, Arend P. van der Veen wrote:

> Hi,
> 
> I have installed RODBC on FreeBSD 4.9 and I am using the PostgreSQL ODBC
> Driver that is distributed with unixODBC 2.2.8.  I can access ODBC Data
> Sources from Open Office so I think that everything is properly
> installed.  When I installed RODBC I had to set
> 
> export LIBS=-L/usr/local/lib
> 
> so that R could locate my ODBC manager.
> 
> I do not have any problems opening database connections and qurey
> tables.  However, when I try and close a connection I get the following
> warning:
> 
> > odbcClose(channel)
> R.bin in free(): warning: chunk is already free
> 
> Is this something that I need to worry about ?

Yes.  We've seen problems with that PostgreSQL driver, and I think you
need to use the one that is distributed by the psqlodbc project (as
described in the RODBC README file!).

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