similar to: RODBC update

Sorry, I was commenting on the previous windows version (version file says 0.5a) (the first one which ran under RW.1.0.0) I have Win NT 4.0 Service pack 5 and R is > version _ platform Windows arch x86 os Win32 system x86, Win32 status major 1 minor 0.0 year 2000 month February day 29 language R > -----Original Message----- > From: Prof Brian

There is a new version of RODBC, 0.9-1, with a new maintainer (me) now on CRAN (Vienna) which works with R 1.6.x. The Windows binary will be there tomorrow, and both will then propagate around CRAN. This has been tested on Linux under unixODBC against MySQL and Postgresql (thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and Excel. The CRAN compilation checks were against

There is a new version of RODBC, 0.9-1, with a new maintainer (me) now on CRAN (Vienna) which works with R 1.6.x. The Windows binary will be there tomorrow, and both will then propagate around CRAN. This has been tested on Linux under unixODBC against MySQL and Postgresql (thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and Excel. The CRAN compilation checks were against

Charles Raux raised the problem of having object names with accented chars in. This is supposed to work, but depends on the machine being set to a locale that allows accented chars, and knowing correctly which they are. Windows being what it is, this is a problem. It seems that with the standard runtime crtdll.dll that rw1011 uses, Windows 9x does not know about locales, whereas NT does but

I have re-built all the compiled packages for R 1.2.0 for Windows, and the set available in CRAN/bin/windows/contrib are now for rw1020. If you are upgrading to rw1020, please replace all the compiled packages you have downloaded by ones from this set. There a few packages available for the first time: RMySQL mlbench netCDF and a few that are not yet running on 1.2.0 on any platform hdf5

I have re-built all the compiled packages for R 1.2.0 for Windows, and the set available in CRAN/bin/windows/contrib are now for rw1020. If you are upgrading to rw1020, please replace all the compiled packages you have downloaded by ones from this set. There a few packages available for the first time: RMySQL mlbench netCDF and a few that are not yet running on 1.2.0 on any platform hdf5

I saw in the R-digest a thread about RODBC. 1) I think that this package is *extremely* valuable : it fulfills a need quite important in the case of iterative (e. g. periodic) analyses. No need to periodically return to your data and re-dumping them ... 2) The current version has a serious bug if your datasets has missing numeric values. M. Lapsley, the original author, is aware of it, but has

Spoetry is a book on S+ by Patrick Burns available on the net at http://www.seanet.com/~pburns/Spoetry/Spoetry.pdf Its about 439 pages with 16 chapters. You can read all about it at http://www.seanet.com/~pburns/Spoetry/ Michael Lapsley

Guido has fixed Rterm hanging on Windows 2000 in interactive and --ess modes. The problem was that 'PulseEvent' doesn't work under 2000 as documented (and I can find nothing about this in MicroSoft's Knowledge Base except that it is known to happen under a debugger). The cross-compiled pre-release at http://www.stats.ox.ac.uk/pub/bdr/RWin/Rpre now incoporates the fix, and we

(1) I do read the posting guide (the fact that I missread o missunderstood something does not imply not reading) (2) I could change NAs to 0 (I know) but I have previously (older versions of R and SQL*Plus) used the same select with the "right" output (namely with 0s). (3) AFAIK "strange" is not a negative remark and does not seem to me at the very least but that is always a

It seems to work smoothly now. Thank you very much. Federico Spinazzi spinazzi@databankgroup.it Databank S.P.A Via Spartaco, 19, ITALY Tel. + 39 02 55002251 -----Messaggio originale----- Da: Prof Brian Ripley <ripley@stats.ox.ac.uk> A: Federico Spinazzi <spinazzi@databankgroup.it> Cc: R-devel@r-project.org <R-devel@r-project.org> Data: lunedì 27 novembre 2000 11.03 Oggetto:

Several of you have kindly sent me examples of bugs in RODBC, but none of them reproduce on my systems. I am fairly sure I know what is happening, and that it is client-specific. (Do empty strings get returned as "", NULL or skipped?) Also, empty character fields were getting mapped to NA. There's a comment in the code that fields need to set to a null string, and that was only

Under which version of R is it supposed to run ? With 1.1.0 under windows NT 4.0 against Access databases it doesn't work, I cannot get the name of the tables, every query I execute returns with "No Data". I'm surely doing something wrong ... Federico Spinazzi spinazzi@databankgroup.it Databank S.P.A Via Spartaco, 19, ITALY Tel. + 39 02 55002251 >Several of you have kindly

There is something strange in R behaviour (perhaps). I have run the same select in Oracle SQL*Plus (version 10.1.0.2.0) and the output comes out with NULLs (which is what it ougth to be). But in R I still get the same result with NAs (no matter I use na.strings or nullstring arguments) An output example follows below: Using na.string="0" and nullstring="0" (sorry by the

I've recently done a lot of re-writing of the internals of RODBC, and have a test version 0.99-6 available. This is a run-up to the release of 1.0. Both the source code and a Windows binary (prepared under rw1062) are available at http:/www.stats.ox.ac.uk/pub/R, and I would appreciate some real users testing this version. It should be more efficient as data frames are transferred to and from

Michael Lapsley was suggesting on R-help direct copies to gif/png/jpeg. The following seems to do a sensible job for me of copying the current device to any bitmap format supported by gs. The manipulation is needed to work around assumptions made by postscript(), and I think better fixed in postscript() (but not a couple of days before a release). I want to make onefile=FALSE work on

Our current intention is to no longer include Rversion.h from R.h as from R 1.6.0 (which is months away). Package maintainers when revising code might like to check if they actually use Rversion.h, and if so include it explicitly. I did a quick grep through the CRAN packages, and in all but one case (mda) the test is for R < 1.2.0, so it may be simplest just to tidy up and add `Depends: R

Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server 2008, Oracle and DB2. More visibly, the documentation has been expanded in several ways, in particular in collecting together advice on using 'schemas' and 'catalogs' in the ?RODBC overview. There is also a test

Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server 2008, Oracle and DB2. More visibly, the documentation has been expanded in several ways, in particular in collecting together advice on using 'schemas' and 'catalogs' in the ?RODBC overview. There is also a test

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