Re: [R] RODBC on linux

From: Marc Schwartz <MSchwartz_at_mn.rr.com>
Date: Thu 27 Jul 2006 - 12:53:45 EST

On Wed, 2006-07-26 at 21:38 -0500, Dirk Eddelbuettel wrote:
> On 26 July 2006 at 20:56, Marc Schwartz wrote:
> | On Wed, 2006-07-26 at 17:52 -0400, Armstrong, Whit wrote:
> | > Anyone out there using Linux RODBC and unixODBC to connect to a
> | > Microsoft SQL server?

> [...]
> | Do you have a Linux ODBC driver for SQL Server? unixODBC is simply the
> | driver manager, not the driver itself.
> |
> | MS does not offer (not surprisingly) an ODBC driver for Unix/Linux.
>
> But there is the FreeTDS project (package freetds-dev in Debian) with its
> associated ODBC drive (package tdsodbc, from the FreeTDS sources). At some
> point a few years ago, a colleague and I were trying to coax that and
> unixOBDC to let R (on Solaris) talk to Sybase (on Solaris) and got it to
> work. MS-SQL is (AFAIK) a descendant of Sybase code originally licensed by
> MS, hence the common FreeTDS code lineage). So it should be doable.
>
> Luckily I haven't needed to talk to MS SQL myself so the usual grain of salt
> alert... And sorry, hence no working .odbc.ini to share.

FreeTDS was one of the options listed on the first URL that I had included. :-)

Here is the direct link:

  http://www.freetds.org/

Regards,

Marc



R-help@stat.math.ethz.ch 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. Received on Thu Jul 27 12:58:18 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Thu 27 Jul 2006 - 14:16:52 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.