Skip to Content.
Sympa Menu

freetds - Re: [freetds] missing data w/ sqlserver2005 and unixodbc

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] missing data w/ sqlserver2005 and unixodbc
  • Date: Sat, 31 Mar 2007 09:44:19 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page