[R-sig-DB] general status query on DBI etc

[ripiey m@iii@g oii st@ts@ox@@c@uk]

On Sat, 20 Jul 2002, David James wrote:

> > 4) RODBC is at CRAN devel (not on the main package distribution
> > page) and the RS-DBI.pdf document suggests that unix ODBC
> > is inadequately developed.  Based on my limited web searching,
> > ODBC does not seem a viable approach for unix at present.
>
> Hmm, that was written sometime ago.  The unixODBC project has
> been making quite a bit of progress, and the driver manager
> seems to be getting quite good (although I haven't tested it too
> much).  My main concern back then was the lack of ODBC drivers.
> Currently the open source DBMS (at least PostsgreSQL and MySQL)
> seem to provide quite decent ODBC drivers.  The availability of

I beg to differ. MySQL's released driver is awful and non compilant even
with the years old version of ODBC it `supports'.  Perhaps the development
version (MyODBC 3.51.03) will be better.

> free/open source drivers on Linux/Unix/MacOS for Oracle, MS SQL
> server, and others is still an issue, AFAIK; (there are good
> commercial drivers for Unix, though).

-- 
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 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595