Re: [R] RODBC on linux

From: Armstrong, Whit <whit.armstrong_at_hcmny.com>
Date: Thu 27 Jul 2006 - 22:06:10 EST


Thanks, everyone.

I'll give freeTDS a try.

Cheers,
Whit

-----Original Message-----
From: Prof Brian Ripley [mailto:ripley@stats.ox.ac.uk] Sent: Thursday, July 27, 2006 1:17 AM
To: Marc Schwartz
Cc: Armstrong, Whit; r-help@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 RODBC.

-- 
Brian D. Ripley,                  ripley@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.


______________________________________________ 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 22:20:22 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 Fri 28 Jul 2006 - 02:16:45 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.