R help - Jul 2006 - RODBC on linux

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





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.


	[[alternative HTML version deleted]]

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.html

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:

https://stat.ethz.ch/mailman/listinfo/r-sig-db

HTH,

Marc Schwartz

Thanks, everyone.

I'll give freeTDS a try.

Cheers,
Whit


-----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
RODBC.

-- 
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.