similar to: Probable bug in RODBC 0.7.x (PR#700)

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

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

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

Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,

Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,

On behalf of Michael Lapsley, who is away. There is a new version of RODBC on CRAN, version 0.8-2. A version compiled for rw1011 will propagate to CRAN tonight. Main differences: - This will work with the up-coming R 1.2.0. - Nulls in databases are handled (more) correctly. The bug that has been reported with repeated entries was it transpires to do with null fields, not empty ones

Here is another of those 'is it a bug or am I using it wrong' questions: I'd be very grateful if someone could help. I am doing a lot of graphs for a thesis at the minute, many of which need (ideally) greek letters in xlab and ylab. This works: >plot(c(1,2,3,4),c(1,2,3,4),xlab=expression( alpha * "-1-m")) > This does not: >

I have just finished a first rough cut of RODBC, a database connectivity addon. In theory it should allow access to any odbc compliant database for which the driver set is installed. On unix this includes MySQL, mSQL and postgres using the unixODBC set. On windows it should include access, sqlserver etc if the odbc drivers are installed. For those who have never taken an interest in this,

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

Some days ago I asked for general methods to access SQL-Databases. Thanks to: Terry Westley [twestley at buffalo.veridian.com], partha_bagchi at hgsi.com, F.Tusell [etptupaf at bs.ehu.es], Michael Lapsley [mlapsley at ndirect.co.uk], Robert Gentleman [rgentlem at jimmy.harvard.edu], Torsten Hothorn [hothorn at statistik.uni-dortmund.de] Several solutions were suggested: (1) using Michael

Dear developers, I wonder would you consider making a save to a graphics file format (as opposed to ps)? What prompts this is that we have just finished my wife's thesis using R heavily for stats and graphs. The combination of latex, bibtex and R generated .eps worked a treat and we were very pleased with both the final outcome and the efficiency of gernerating it, especially when all the

I am compiling R 2.11.0 on a RHEL5.3 box using the following settings ./configure --with-readline=yes --enable-R-shlib=yes --with-x=yes --with-blas="-llibptf77blas -lpthread -llibatlas" --prefix=/usr/local/R-2.11.0 JAVA_HOME=$JAVA_HOME CPPFLAGS="-I/usr/local/unixODBC-2.3.0/include" I have compiled and installed unixODBC-2.3.0 (64-bit) in /usr/local and can connect to and

Dear list, What is the correct approved way to abort a library install if the c fails to build? I am tarting up my odbc library, and I would like to stop the install process if the needed header files and libraries are not present on the system. Error messages flash past so fast that it is easy to miss their significance. Michael ---------------------------------- E-Mail: Michael Lapsley

Would anyone care to comment if this is the best solution to this problem? > trygrep <-function(x,y) + if(grep(x,y)) + print("yes") else + print("NO") > >trygrep("foo","bafoobar") [1] "yes" > > trygrep("foo","bar") Error in if (grep(x, y)) print("yes") else print("NO") : missing value

Here is a nasty one: (0.65.1 on linux) > plot(c(1,2,3,4),c(2,4,6,8),log="Y") Segmentation fault (core dumped) [ml at athome ml]$ Seems the bug is in errorcall(). yes, I know the syntax is wrong, but it is an easy mistake to make and it is inconvenient to lose the work space at times. Michael ---------------------------------- E-Mail: Michael Lapsley <mlapsley at

Anyone out there using Linux RODBC and unixODBC to connect to a Microsoft SQL server? If possible can someone post a sample .odbc.ini file? I saw a few discussions on the archives a few years ago, but no config file details were available. Thanks, Whit This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended

Dear all, platform i386-pc-mingw32 arch x86 os Win32 system x86, Win32 status major 1 minor 2.3 year 2001 month 04 day 26 language R I wrote the following to import tables in different database formats (Access, Visual FoxPro, etc.): getTable <-

Hi, Version info: R: 1.5.1 RODBC: 0.8.3 Oracle: 8.1.7 unixODBC: 2.2.2 Easysoft ODBC driver: 1.0.0.6 SunOS/Solaris: 5.7 I'm trying to get RODBC working with Oracle on Solaris. I've installed unixODBC and the Easysoft ODBC driver. There are no problems connecting to the DB and executing queries using unixODBC's isql interactive client. Using R and RODBC however, I can open a connection

Dear R-helpers, I wonder if I could impose upon you for forther assistance, this time with dataframes: hopefully this will be of general interest, as I personally have found them hard to get to grips with. I was trying to transpose rows and cols and move col1 to the names. Then all sorts of things go wrong. Although the end result looks the same, page() shows the structure to be quite