From spinazzi@databankgroup.it  Mon Nov 27 08:34:46 2000
From: spinazzi@databankgroup.it (Federico Spinazzi)
Date: Mon, 27 Nov 2000 08:34:46 -0000
Subject: R: [Rd] RODBC
Message-ID: <006301c0584c$e6d98df0$0a00a8c0@bellview>

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 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 being done for the first row.
>
>If my diagnosis is right, I have a fix (and have simpilfied the code a
>lot en route).
>
>http://www.stats.ox.ac.uk/pub/bdr/RODBC/RODBC_0.7-2.tar.gz  (source)
>http://www.stats.ox.ac.uk/pub/bdr/RODBC/RODBC.zip  (Windows)
>
>I'd be grateful for confirmation (or otherwise).
>
>BTW, although I have altered the code to compile under R-devel, it does not
>work correctly for me as yet.
>
>--
>Brian D. Ripley,                  ripley@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
>
>-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
.-.-
>r-devel mailing list -- Read
http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
>Send "info", "help", or "[un]subscribe"
>(in the "body", not the subject !)  To: r-devel-request@stat.math.ethz.ch
>_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
._._

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-devel-request@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._


R: [Rd] RODBC
Federico Spinazzi