Re: [R] RODBC odbcCloseAll odbcClose Windows XP

From: Jason Fisher <stormplot_at_gmail.com>
Date: Wed 20 Apr 2005 - 07:43:22 EST

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@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@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@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@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@ucmerced.edu
url: https://ucmeng.net/people/jfisher
fax: 209-724-2912

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Wed Apr 20 07:51:57 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:31:17 EST