[R] RODBC odbcCloseAll odbcClose Windows XP

[Jason Fisher]

OK, I decided to try something new.  Rather than installing RODBC via:

install.packages("RODBC", .Library, repos="http://cran.r-project.org", 
                method="internal", destdir=getwd())

I instead downloaded the RODBC_1.1-3.zip file from
http://www.bioconductor.org/CRAN/ and installed through the Windows R
GUI.  Installing the package using the local zip file worked (no more
error message).  The library(help=RODBC) gives

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

Note, using install.packages() with http://cran.r-project.org produces
the same build info:
Built: R 2.1.0; i386-pc-mingw32; 2005-04-09 19:24:26; windows

Jason


On 4/19/05, Prof Brian Ripley <ripley at stats.ox.ac.uk> wrote:
> 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
> 


-- 
Jason C. Fisher, Research Assistant
University of California, Merced
School of Engineering

Mailing Address:
P.O. Box 2039
Merced, CA 95344

Physical Address (couriers/parcels):
4225 N. Hospital Road, Bldg 1200
Atwater, CA 95301

email: jfisher at ucmerced.edu
url: https://ucmeng.net/people/jfisher
fax: 209-724-2912