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
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'Works for me on both Windows Server 2003 and Windows NT4.0 SP2. Have you installed the most recent version of RODBC (1.1-3) compiled for R-2.1.0? Anyway, please try to reinstall "RODBC". Uwe Ligges> Implementation of the two functions in previous versions of R worked flawlessly. > > Thank you, > > Jason Fisher > > ______________________________________________ > R-help at 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
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