[R-sig-DB] [R] RODBC on linux

[Jeffrey Horner]

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 using stats.ox.ac.uk] 
> Sent: Thursday, July 27, 2006 1:17 AM
> To: Marc Schwartz
> Cc: Armstrong, Whit; r-help using 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 using 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.