[R] RODBC odbcCloseAll odbcClose Windows XP

[Prof Brian Ripley]

Works for me.  Did you update RODBC with update.packages(checkBuilt=TRUE)?
The version I downloaded says in library(help=RODBC)

Built:                R 2.1.0; i386-pc-mingw32; 2005-04-09 19:24:26;
                       windows

and for definiteness

pedump -e /R/library/RODBC/lib/RODBC.dll | grep Close

     0001    00001760  RODBCClose
     0002    00001840  RODBCCloseAll

Sorry, not much I can do to help if you have that version.


On Tue, 19 Apr 2005, Jason Fisher wrote:

> Hello...
>
> After installing the precompiled version of R 2.1.0 (congratulations
> to the R Development Core Team) for Windows XP (Service Pack 2), I'm
> having problems with the "odbcCloseAll" and "odbcClose" functions
> within the "RODBC" package.  I get pretty much the same error message
> for both functions:
>
> odbcCloseAll() produces:
> Error in .Call("RODBCCloseAll", PACKAGE = "RODBC") :
>        "C" function name not in DLL for package 'RODBC'
>
> odbcClose(channel) produces:
> Error in .Call("RODBCClose", attr(channel, "handle_ptr"), PACKAGE = "RODBC") :
>        "C" function name not in DLL for package 'RODBC'
>
> Implementation of the two functions in previous versions of R worked flawlessly.
>
> Thank you,
>
> Jason Fisher

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