r-help-boun...@r-project.org wrote on 01/25/2010 03:32:41 PM:
Jim writes to David:
> These days I tend to use RJDBC http://www.rforge.net/RJDBC/ which is a
> bit less of a hassle.
>
> Hint use the jtds driver http://jtds.sourceforge.net/
> ...
> >
> > I have a client running Microsoft SQL Server. I am interested in
> ways of accessing data from this server using R.
We use RODBC here, with some snags:
a) The column types in the dataframes returned by sqlFetch() are
independent of the table definitions; instead they seem to be based on the
values in each column.
b) sqlQuery() will report an error if the query returns no rows, which is
perfectly legal and even expected when performing an update to a table.
c) Probably others too, but my memory is short today.
Good question, I'm hoping for some tips on this myself.
cur
--
Curt Seeliger, Data Ranger
Raytheon Information Services - Contractor to ORD
seeliger.c...@epa.gov
541/754-4638
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
