r-help-bounces@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.curt@epa.gov
541/754-4638

	[[alternative HTML version deleted]]

