FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Hi,

There should be some more log file after this... 
after the dump of the header and data received...

There would be two possibilities I would think.

1) we have a bug, as yet unidentified.
2) the calling program (perl/DBD::Sybase) hasn't allocated enough space to 
receive the data (64k)

Naturally I'm assuming the latter...

Bill


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of John Gilmore-Baldwin
Sent: 05 April 2006 08:56
To: FreeTDS AT lists.ibiblio.org
Subject: [freetds] Data-conversion resulted in overflow on image column


I¹m trying to extract the contents of a column of type image in a SQL 2000
server. But it is giving me the above stated error and I¹m hoping somebody
can tell me a nice, easy way to correct the problem.

I¹ve seen messages about UNIQUE IDENTIFIER not being recognized, but didn¹t
see much about image columns.

I¹m specifying a  specific row, and requesting only the column that contains
the ³image² data. Really it¹s a document file. It could be a pretty large
document.

I¹m using perl on Mac OS X (Tiger), with the DBD::Sybase module, and freetds
0.63

Here¹s a log dump. This is what precedes the data, which takes up way too
much space to attach here. There are no errors that I see, though.

23:47:24.832734 processing result tokens.  marker is  81(TDS7_RESULT)
23:47:24.832934 tds_free_all_results()
23:47:24.832983 processing TDS7 result. set current_results to tds->res_info
23:47:24.833017 tds_get_string: reading 36 from wire to give 18 to client.
23:47:24.833054 tds_get_string: reading 6 from wire to give 3 to client.
23:47:24.833083 tds7_get_data_info:1558:
        colname = doc (3 bytes)
        type = 34 (image)
        server's type = 34 (image)
        column_varint_size = 4
        column_size = 64512 (64512 on server)
23:47:24.833119 ct_results() process_result_tokens returned 1 (type 4049)
23:47:24.833149 processing result tokens.  marker is  d1(ROW)
23:47:24.833176 ct_results() process_result_tokens returned 1 (type 4040)
23:47:24.833205 ct_res_info()
23:47:24.833230 ct_res_info(): Number of columns is 1
23:47:24.833261 ct_describe()
23:47:24.833288 _ct_get_client_type(type 34, user 0, size 64512)
23:47:24.833314 ct_describe() datafmt->datatype = 11 server type 34
23:47:24.833373 ct_bind() datafmt count = 1 column_number = 1
23:47:24.833498 ct_fetch()
23:47:24.833539 processing row tokens.  marker is  d1(ROW)
23:47:24.833568 processing row.  column is 0 varint size = 4
23:47:24.833595 processing row.  column size is 64512
23:47:24.833620 clearing column 0 NULL bit
23:47:24.855376 Received header

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the 
sender, delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------