RODBC on linux
Armstrong, Whit wrote:
Thanks, everyone. I'll give freeTDS a try.
One final hitch to be aware of when using FreeTDS:
MS SQL Server authenticates db connections in two different ways (well
actually three, but it's just the combination of 1 and 2):
1) Sql server authenticates the connection, meaning you must have
an SQL server account. FreeTDS will handle this fine.
2) the SQL server OS authenticates the connection with an NT Domain
login. That's the domain\username you use to login to your Windows
machine. FreeTDS will ONLY handle this over TCP/IP, not over DCE/RPC,
so be aware.
More info here:
http://www.freetds.org/userguide/domains.htm
and here:
http://www.freetds.org/userguide/troubleshooting.htm
Jeff
-----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. ------------------------------------------------------------------------
______________________________________________ R-help at 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.