[R] RODBC on linux

Armstrong, Whit whit.armstrong at hcmny.com
Thu Jul 27 14:06:10 CEST 2006

Thanks, everyone.

I'll give freeTDS a try.


-----Original Message-----
From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk] 
Sent: Thursday, July 27, 2006 1:17 AM
To: Marc Schwartz
Cc: Armstrong, Whit; r-help at stat.math.ethz.ch
Subject: Re: [R] RODBC on linux

On Wed, 26 Jul 2006, 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?
> > 
> > If possible can someone post a sample .odbc.ini file?
> > 
> > I saw a few discussions on the archives a few years ago, but no 
> > config file details were available.
> > 
> > Thanks,
> > Whit
> Whit,
> 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.
> There are resources available however and these might be helpful:
> http://www.sommarskog.se/mssql/unix.html
> Note that Easysoft provides (at a cost) an ODBC-ODBC bridge for 
> Unix/Linux platforms which supports ODBC connections to SQL Server:
> http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.ht
> ml

Several people have successfully used that, from the earliest days of
RODBC: I believe it was part of Michael Lapsley's motivation to write

Brian D. Ripley,                  ripley at 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 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

This e-mail message is intended only for the named recipient(s) above. It may contain confidential information. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and delete the message and any attachment(s) from your system. Thank you.

More information about the R-help mailing list