[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    [freetds] using sqsh to fetch an IMAGE column
From:       "Chris Wesley" <cwwesley () udlug ! org>
Date:       2002-07-25 21:17:59
[Download RAW message or body]

I have sqsh (2.1) working fine with freetds (0.53) to query an SQL2000
server.  However when I try to retrieve a an IMAGE column, I only get the
first 4K of the data.  If I have TDSDUMP logged to a file, I can see the
whole 'transaction' happen, including this at the end:

<all the stuff you expect to see>
<the hex data from the IMAGE column>

2002-07-25 13:54:47 inside _ct_bind_data()
2002-07-25 13:54:47 inside _ct_get_server_type()
2002-07-25 13:54:47 inside _ct_bind_data() converting column 0 from type
34 to type 34
2002-07-25 13:54:47 inside _ct_bind_data() setting source length for 0 =
4096
2002-07-25 13:54:47 inside _ct_bind_data() conversion done len = 4096
bindfmt = 0
2002-07-25 13:54:47 inside _ct_bind_data() length binding len = 4096
2002-07-25 13:54:47 inside _ct_get_server_type()
2002-07-25 13:54:47 inside _ct_get_server_type()
2002-07-25 13:54:47 inside ct_fetch()
2002-07-25 13:54:47 processing row tokens.  marker is  fd
2002-07-25 13:54:47 inside ct_results()
2002-07-25 13:54:47 inside ct_res_info()
2002-07-25 13:54:47 inside ct_results()
2002-07-25 13:54:47 inside ct_cmd_drop()
2002-07-25 13:54:47 inside ct_con_props() action = CS_GET property = 26
2002-07-25 13:54:47 inside ct_close()
2002-07-25 13:54:47 inside ct_con_drop()
2002-07-25 13:54:47 inside ct_exit()

... that's the end.
Am I correct in suspecting that these two lines contain the information
that is of concern to me? :
2002-07-25 13:54:47 inside _ct_bind_data() conversion done len = 4096
bindfmt = 0
2002-07-25 13:54:47 inside _ct_bind_data() length binding len = 4096

If so, what IS the information here, and is there anything I can do to
increase the length of retrieved data on an IMAGE column?

    Thanks for any help,
    ~Chris

---
You are currently subscribed to freetds as: [freetds@progressive-comp.com]
To unsubscribe, forward this message to leave-freetds-113879Q@franklin.oit.unc.edu
[prev in list] [next in list] [prev in thread] [next in thread]