FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

magic hat wrote:
> I get 'no data found'. 
> 
> I've confirmed that the query returns data when I execute using isql. 
> 
> The freetds log file generated from this operation is 3.5MB, so I'm a
> little unclear as to where to begin looking for problems

Start near the end.  If you want, use tail(1) to grab just the last 1000
lines or so; that will be plenty. Or use grep -n to find part of your
query in the log and then back up a few hundred lines from there (just to
be safe).  

*Maybe* you'll see an error message.  What you want to know is whether or
not the data were returned from the server.  I would guess they were, and
that some higher layer punted.  FreeTDS doesn't care what kind of query
you send, and if tsql can execute your query, the ODBC library usually
can, too.  

Alternatively, sometimes connection properties of the interactive tool and
the application differ.  But I bet both connections use ODBC, minimizing
(but not eliminating) the possible differences, and furthermore I don't
see anything in your query that would trip over that kind of difference.  

You might also want to double-check account permissions.  

HTH.  

--jkl