FreeTDS Development Group

[magic hat <magic_hat60622 AT yahoo.com>]

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.