X-Recipient: archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status: No, hits=-3.4 required=5.0	tests=AWL,BAYES_00,DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM,KHOP_RCVD_TRUST,RCVD_IN_DNSWL_LOW,RCVD_IN_HOSTKARMA_YE
X-Spam-Check-By: sourceware.org
MIME-Version: 1.0
Date: Sun, 22 Apr 2012 11:53:45 -0700
Message-ID: <CAPCJcd5F6vDNKBtu9r3QgQsYTEUKNW4RUXQ+jaQFEHxCw62JZg@mail.gmail.com>
Subject: R-2.14.2-1 and RODBC 1.3-5 package (W7)
From: Dario Buttari <dario DOT buttari AT gmail DOT com>
To: cygwin AT cygwin DOT com
Content-Type: text/plain; charset=ISO-8859-1
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

I am using R 2.14.2-1 under cygwin 1.7.12-1 in Windows 7 Professional
Service Pack 1.
In the past I found very desirable to modify the RODBC package to
access the Windows ODBC connections in R under cygwin:
http://sourceforge.net/mailarchive/forum.php?thread_name=CAPCJcd5K7-9TdK6AqEzy9XpBVw68QeOYz9CY-Bo6%2BoqRu_UsGA%40mail.gmail.com&forum_name=cygwin-ports-general

This enables NTLM authenticated connections to Oracle and sql server
databases using the Windows ODBC drivers.
I am considering to submit the corresponding patch request (see below)
to the RODBC 1.3-5 package maintainers.
The patch is pretty much an exact copy of an old patch present in
cygwin-ports: http://cygwin-ports.git.sourceforge.net/git/gitweb.cgi?p=cygwin-ports/R-RODBC;a=summary
Before installing the package I also a need to define
ac_cv_search_SQLTables as specified below.

I am a novice using R and cygwin. Is there a way to patch
RODBC_1.3-5.tar so that ac_cv_search_SQLTables is automatically
defined when the package is installed under cygwin? Would it be better
to leave it undefined, and define it at the command prompt as
specified below? Maybe in that way people will still be able to use
libiodbc-devel library if they want to do so. Let me know if you have
any advice on how to proceed.
Thanks, Dario


Modify RODBC\src\RODBC.c in RODBC_1.3-5.tar as follows:
----------------------------------------------------------------------
--- RODBC.c_bk  2012-03-08 22:01:02.000000000 -0800
+++ RODBC.c     2012-04-22 09:14:54.353868700 -0700
@@ -41,6 +41,12 @@
 #include <string.h>
 #include <limits.h> /* for INT_MAX */

+#ifdef __CYGWIN__
+#define WIN32_LEAN_AND_MEAN
+#include <windows.h>
+#undef WIN32
+#endif
+
 #define MAX_CHANNELS 1000
 #include <sql.h>
 #include <sqlext.h>
----------------------------------------------------------------------

Installation procedure under Cygwin to access the windows ODBC DNSs:
export ac_cv_search_SQLTables="-lodbc32"
R CMD INSTALL RODBC_1.3-5.tar.gz

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple