[R] RODBC odbcCloseAll odbcClose Windows XP

Jason Fisher stormplot at gmail.com
Tue Apr 19 23:43:22 CEST 2005


Disregard that last message.  It seems to be a temperamental problem. 
Sometimes it works sometimes it doesn't.

Jason Fisher

On 4/19/05, Jason Fisher <stormplot at gmail.com> wrote:
> 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
> 


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




More information about the R-help mailing list