[R-sig-DB] R MS-Sql database connection package
Prof Brian Ripley
r|p|ey @end|ng |rom @t@t@@ox@@c@uk
Thu Oct 7 19:43:43 CEST 2004
The message is pretty clear: your DESCRIPTION file is invalid. I expect
it always was, but 2.0.0 has much better tests of validity, since it
relies of it a lot more. I would guess R CMD check fails under 1.9.1 too.
The R project has no expressed any need to another connection to SQL
Server (RODBC works perfectly well), and has no resources to support such
an effort. You seem to have the wrong end of the stick: CRAN will tell
you if your code fails the checks, but it is up to you to fix your own
errors.
On Thu, 7 Oct 2004 rikbradt using xs4all.be wrote:
> Hello,
>
> I ran some extra tests today with our R MS-SqlServer database connection
> package. It appears the package still works with the most recent versions
> of freetds. The connection package was still working with R Version 1.9.1.
> It stopped working with R Version 2.0.0.
>
> I've pasted a log that gives you and idea of how this component works
> and where the error in the compilation under R Version 2.0.0 occurs.
>
> In case you want to review the code I'm willing to post/mail it to an
> approriate address. Within a few weeks we plan to start working on
> this code, so that we have a functional database component for R Version
> 2.0.0. in the beginning of 2005.
>
> Regards,
>
> Rik
>
> ----------------------- LOG -----------------------
> lt14008:/opt/R-1.9.1/bin # ./R CMD INSTALL
> --configure-args='--with-freetds-dir=/opt/freetds-0.62.4/'
> /usr/src/tgz/RDBLib_0.1-2.tar.gz
> * Installing *source* package 'RDBLib' ...
> creating cache ./config.cache
> checking how to run the C preprocessor... cc -E
> checking for dbinit in -lsybdb... no
> checking for tds_configs.h... no
> updating cache ./config.cache
> creating ./config.status
> creating src/Makevars
> ** libs
> gcc -I/opt/R-1.9.1/lib/R/include -I/opt/freetds-0.62.4//include
> -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -g -O2 -c
> RS-DBI.c -o RS-DBI.o
> gcc -I/opt/R-1.9.1/lib/R/include -I/opt/freetds-0.62.4//include
> -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -g -O2 -c
> RS-DBLib.c -o RS-DBLib.o
> gcc -shared -L/usr/local/lib -o RDBLib.so RS-DBI.o RS-DBLib.o
> -L/opt/freetds-0.62.4//lib -lsybdb
> ** R
> ** help
> >>> Building/Updating help pages for package 'RDBLib'
> Formats: text html latex example
> DBLib text html latex example
> S4R text html latex
> SQLDataType text html latex example
> callProc text html latex
> commit text html latex example
> dbApply.DBLibResultSet text html latex example
> dbApply text html latex example
> dbConnect text html latex example
> dbExec text html latex example
> dbExecStatement text html latex example
> dbManager text html latex example
> describe text html latex example
> fetch text html latex example
> getManager text html latex example
> getNumRows text html latex example
> getTable text html latex example
> isIdCurrent text html latex example
> isSQLKeyword text html latex example
> load text html latex example
> make.SQL.names text html latex example
> metaData text html latex example
> methods.DBLib text html latex example
> quickSQL text html latex example
> setDataMappings text html latex example
> supportObjects text html latex
> * DONE (RDBLib)
> lt14008:/opt/R-1.9.1/bin # ./R
>
> R : Copyright 2004, The R Foundation for Statistical Computing
> Version 1.9.1 (2004-06-21), ISBN 3-900051-00-3
>
> R is free software and comes with ABSOLUTELY NO WARRANTY.
> You are welcome to redistribute it under certain conditions.
> Type 'license()' or 'licence()' for distribution details.
>
> R is a collaborative project with many contributors.
> Type 'contributors()' for more information and
> 'citation()' on how to cite R in publications.
>
> Type 'demo()' for some demos, 'help()' for on-line help, or
> 'help.start()' for a HTML browser interface to help.
> Type 'q()' to quit R.
>
> WARNING: UTF-8 locales are not currently supported
>
> > library(RDBLib)
> Error in dyn.load(x, as.logical(local), as.logical(now)) :
> unable to load shared library
> "/opt/R-1.9.1/lib/R/library/RDBLib/libs/RDBLib.so":
> libsybdb.so.4: cannot open shared object file: No such file or directory
> Error in library(RDBLib) : .First.lib failed
> > q()
> Save workspace image? [y/n/c]: n
> lt14008:/opt/R-1.9.1/bin # export
> LD_LIBRARY_PATH=:/opt/freetds-0.62.4/lib:$LD_LIBRARY_PATH
> lt14008:/opt/R-1.9.1/bin # ./R
>
> R : Copyright 2004, The R Foundation for Statistical Computing
> Version 1.9.1 (2004-06-21), ISBN 3-900051-00-3
>
> R is free software and comes with ABSOLUTELY NO WARRANTY.
> You are welcome to redistribute it under certain conditions.
> Type 'license()' or 'licence()' for distribution details.
>
> R is a collaborative project with many contributors.
> Type 'contributors()' for more information and
> 'citation()' on how to cite R in publications.
>
> Type 'demo()' for some demos, 'help()' for on-line help, or
> 'help.start()' for a HTML browser interface to help.
> Type 'q()' to quit R.
>
> WARNING: UTF-8 locales are not currently supported
>
> > library(RDBLib)
> > m2 <- DBLib()
> > dblib <- dbConnect(m2, server="servername", dbname="dbname",
> user="username", passwd="password")
> > Param <- "someparam"
> > sqlstr <- paste("SELECT * FROM sometable WHERE (Parameter =
> '",Param,"')", sep="")
> > rs <- dbExecStatement( dblib, sqlstr )
> > scale <- fetch(rs, n=-1)
> > scale
> ...
> >
>
>
>
>
> lt14008:/opt/R-2.0.0/bin # ./R CMD INSTALL
> --configure-args='--with-freetds-dir=/opt/freetds-0.62.4/'
> /usr/src/tgz/RDBLib_0.1-2.tar.gz
> * Installing *source* package 'RDBLib' ...
> creating cache ./config.cache
> checking how to run the C preprocessor... cc -E
> checking for dbinit in -lsybdb... no
> checking for tds_configs.h... no
> updating cache ./config.cache
> creating ./config.status
> creating src/Makevars
> Error: Invalid DESCRIPTION file
>
> Malformed maintainer field.
>
> See the information on DESCRIPTION files in section 'Creating R
> packages' of the 'Writing R Extensions' manual.
> Execution halted
> ERROR: installing package DESCRIPTION failed
> lt14008:/opt/R-2.0.0/bin #
> ----------------------- /LOG -----------------------
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
>
--
Brian D. Ripley, ripley using 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
More information about the R-sig-DB
mailing list