DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:message-id:date:from:mime-version:to:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	 q=dns; s=default; b=JFdZq/62r8CzWLLs1cuo5MlmiD9ssN7NHy9Ib+mYEJt
	I8mu12fWnj5pxHY3+OdBZKIObJgXEdyQ9trIaq4P0e31qTKcUzIvwLNNf5V8SHVY
	BlVaSeEfg+cvzLVcvuUJ7KDsdF5GatLcz8++S6Ofuw6QmDIO1PrRiJewMTjIgonA
	=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Message-ID: <533079D8.3000703@breisch.org>
Date: Mon, 24 Mar 2014 14:30:48 -0400
From: "Chris J. Breisch" <chris DOT ml AT breisch DOT org>
User-Agent: Postbox 3.0.9 (Windows/20140128)
MIME-Version: 1.0
To: "cygwin AT cygwin DOT com" <cygwin AT cygwin DOT com>
Subject: Re: SQL server utility not working when invoked(from a asp.net application) using cygwin
References: <CAN=kAG7tkCxitPj+5k+otz+Sugyjep-KgJ=sq+oyTYquSdaMRQ AT mail DOT gmail DOT com> <532F2E28 DOT 8020406 AT breisch DOT org>
In-Reply-To: <532F2E28.8020406@breisch.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Chris J. Breisch wrote:
>
> Can you give more specifics on how it fails? And is it possible for you
> to upgrade to a more recent version of Cygwin? I'm doing almost all of
> this except for the ASP.net part, and I have no problems. I do this at
> work, and I'm not at the office right now. It's possible I quote the
> arguments differently. I can check in the morning. I also use Windows
> authentication and not SQL authentication, but that shouldn't matter. In
> fact, of the two, SQL authentication is the way less likely to cause
> issues.
>

I checked on what I'm doing in my script. Here's an exact line of code 
from my shell script:
    ${SQLCMD} -E -d ${_db} -S ${_server} -o ${_dosOutput} -Q "${_query}"

Where the variables are defined as follows:
SQLCMD="sqlcmd.exe"
_db=<database name>
_server=<server name>
_dosOutput=<output file name>
_query=<query string>

Note that I'm not using bash redirection, but the sqlcmd option to send 
output to a file. The -E tells sqlcmd to use Windows Authentication 
(actually it uses impersonation, which has it's own set of quirks, but 
that's not an issue for you), rather than using the -U and -P options as 
you are.

I did notice that in your original post you said -Q "sp_helpuser abc". I 
doubt that this is the problem, but -Q "exec sp_helpuser abc" is 
preferred. In my case, I'm not calling a stored procedure but passing an 
actual SQL select, insert, or update to sqlcmd. That shouldn't make any 
difference, though.

I also recently had a problem executing something with sqlcmd, as I 
mistyped "-S" as "-s". I didn't notice that tiny typo for hours and 
pulled out quite a bit of hair. Make sure the case is correct for all 
your options.

Without additional details on what is or isn't happening, this is as 
much assistance as I can provide.

-- 
Chris J. Breisch

--
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