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
RODBC odbcCloseAll odbcClose Windows XP
5 messages · Uwe Ligges, Brian Ripley, 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
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
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