Re: [R] RODBC on linux

From: Jeffrey Horner <jeff.horner_at_vanderbilt.edu>
Date: Fri 28 Jul 2006 - 00:53:52 EST

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


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 Fri Jul 28 01:09:07 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:21:16 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.