Re: [R] RODBC on linux

From: Marc Schwartz <>
Date: Thu 27 Jul 2006 - 11:56:49 EST

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


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:

Note that Easysoft provides (at a cost) an ODBC-ODBC bridge for Unix/Linux platforms which supports ODBC connections to SQL Server:

I am using RODBC to connect from a FC5 system to an Oracle 10g server running on RHEL, however Oracle provides the ODBC driver for Linux that can work with the unixODBC facilities.

Also, note that there is a R-sig-DB e-mail list:

HTH, Marc Schwartz mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Thu Jul 27 12:00:04 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 - 16:16:36 EST.

Mailing list information is available at Please read the posting guide before posting to the list.