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: magic hat <magic_hat60622 AT yahoo.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] missing data w/ sqlserver2005 and unixodbc
  • Date: Mon, 2 Apr 2007 14:56:43 -0700 (PDT)

I am getting an error in the last couple hundred lines of the log:

net.c:542:Received packet
0000 6d 79 54 53 00 d0 00 00-00 53 00 70 00 72 00 61 |myTS.... .S.p.r.a|
... more lines like this truncated for brevity....
token.c:1920:processing row. column size is 208
token.c:1863:tds_get_data: column 49, type 39, varint size 2
... truncated...
token.c:1863:tds_get_data: column 77, type 36, varint size 1
token.c:1920:processing row. column size is 16
token.c:526:processing result tokens. marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
was_cancelled = 0
error = 1
done_count_valid = 0
net.c:446:Received header
0000 04 01 00 11 00 3a 01 00- |.....:..|

net.c:542:Received packet
0000 fd 20 00 fd 00 00 00 00-00 |. ...... .|

token.c:526:processing result tokens. marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
was_cancelled = 1
error = 0
done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE

Any idea how to proceed on this?

Thanks for all your help!







Message: 6
Date: Sat, 31 Mar 2007 09:44:19 -0400
From: "James K. Lowden"
Subject: Re: [freetds] missing data w/ sqlserver2005 and unixodbc
To: FreeTDS Development Group
Message-ID: <20070331094419.37caaa56.jklowden AT freetds.org>
Content-Type: text/plain; charset=US-ASCII

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




---------------------------------
Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.




Archive powered by MHonArc 2.6.24.

Top of Page