The first non-maintenance update of RODBC since January 2003 is now on
CRAN and will soon propagate to mirrors. From the ChangeLog:
* Select the decimal point from Sys.localeconv.
* Add an external reference and finalizer so open channels get
closed at the end of the session or when there is no R object
referring to them.
* There is no longer a restriction to 16 channels.
* Add NAMESPACE.
* odbcConnect{Access,Dbase,Excel} allow a missing file name
(and will bring up a dialog box to search for it).
* odbcGetInfo returns more information in a 8-element character
vector (based on an idea of Matthew Dowle).
* The C code calls SQLExecuteDirect rather than SQLExecute and
does not call SQLCloseCursor, based on a problem report from
Matthew Dowle using MS SQLServer. Repeated calls to
sqlGetResults now work.
* New function sqlFetchMore.
* Table names in Access with embedded spaces are mapped to the
[name space] form which Access requires.
* Table creation no longer removes _ from column names.
* New functions get/setSqlTypeInfo and the typeInfo argument to
sqlSave allow users to specify the mapping from R types to DBMS
datatypes. sqlSave also allows the specification of DBMS
datatypes by column.
* It is now possible to write more than 255 chars to a field with
sqlSave and sqlUpdate.
* Dates and timestamps are now read as 'Date' and
'POSIXct'
columns by sqlGetResults (unless as.is = TRUE for the column).
I have been able to test SQL Server reasonably extensively this time
around, as well as MySQL, PostgreSQL, Access, Excel and SQLite.
--
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
_______________________________________________
R-packages mailing list
R-packages at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-packages
