Re: [R] RODBC on linux
Thanks, everyone. I'll give freeTDS a try. Cheers, Whit -Original Message- From: Prof Brian Ripley [mailto:[EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, UKFax: +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.
Re: [R] 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:[EMAIL PROTECTED] 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.
[R] 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]] __ 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.
Re: [R] RODBC on linux
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 __ 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.
Re: [R] RODBC on linux
On 26 July 2006 at 20:56, 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? [...] | 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. But there is the FreeTDS project (package freetds-dev in Debian) with its associated ODBC drive (package tdsodbc, from the FreeTDS sources). At some point a few years ago, a colleague and I were trying to coax that and unixOBDC to let R (on Solaris) talk to Sybase (on Solaris) and got it to work. MS-SQL is (AFAIK) a descendant of Sybase code originally licensed by MS, hence the common FreeTDS code lineage). So it should be doable. Luckily I haven't needed to talk to MS SQL myself so the usual grain of salt alert... And sorry, hence no working .odbc.ini to share. Dirk -- Hell, there are no rules here - we're trying to accomplish something. -- Thomas A. Edison __ 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.
Re: [R] RODBC on linux
On Wed, 2006-07-26 at 21:38 -0500, Dirk Eddelbuettel wrote: On 26 July 2006 at 20:56, 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? [...] | 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. But there is the FreeTDS project (package freetds-dev in Debian) with its associated ODBC drive (package tdsodbc, from the FreeTDS sources). At some point a few years ago, a colleague and I were trying to coax that and unixOBDC to let R (on Solaris) talk to Sybase (on Solaris) and got it to work. MS-SQL is (AFAIK) a descendant of Sybase code originally licensed by MS, hence the common FreeTDS code lineage). So it should be doable. Luckily I haven't needed to talk to MS SQL myself so the usual grain of salt alert... And sorry, hence no working .odbc.ini to share. FreeTDS was one of the options listed on the first URL that I had included. :-) Here is the direct link: http://www.freetds.org/ Regards, Marc __ 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.
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.html 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, [EMAIL PROTECTED] 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, UKFax: +44 1865 272595 __ 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] RODBC on linux
I am using RODBC 1.1-2 with R 2.0.0 on a Debian box with a singel Pentium processor. My database is Informix 7.32. When I run a sql query I get the table header back but no data is selected. Please note this example: Table t1 has two columns, a and b. The table is populated with three rows. Thi si the definition of the table: Column name TypeNulls a smallintyes b integer yes sqlQuery(pricedb, select * from t1) [1] a b 0 rows (or 0-length row.names) class(a$a) [1] integer class(a$b) [1] integer using my C code on the same box, utalizing teh same odbc installation I get: 12 34 56 Does anyone have an idea why I get the table header but no data? Also, sqlTables() return no rows. sqlTables(pricedb) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE [5] REMARKS 0 rows (or 0-length row.names) __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Re: [R] RODBC on linux
If you look in the RODBC help pages for odbcConnect you will see this mentioned with respect to Oracle and Sybase. Try the fix mentioned there. On Wed, 8 Dec 2004, Omar Lakkis wrote: I am using RODBC 1.1-2 with R 2.0.0 on a Debian box with a singel Pentium processor. My database is Informix 7.32. When I run a sql query I get the table header back but no data is selected. Please note this example: Table t1 has two columns, a and b. The table is populated with three rows. Thi si the definition of the table: Column name TypeNulls a smallintyes b integer yes sqlQuery(pricedb, select * from t1) [1] a b 0 rows (or 0-length row.names) class(a$a) [1] integer class(a$b) [1] integer using my C code on the same box, utalizing teh same odbc installation I get: 12 34 56 Does anyone have an idea why I get the table header but no data? Also, sqlTables() return no rows. sqlTables(pricedb) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE [5] REMARKS 0 rows (or 0-length row.names) __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html -- Brian D. Ripley, [EMAIL PROTECTED] 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, UKFax: +44 1865 272595 __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html