Re: [R] RODBC odbcCloseAll odbcClose Windows XP

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

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

______________________________________________
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:41:21 2005

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