freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Pulling Blobs from SQL Server 2000/05/08

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Pulling Blobs from SQL Server 2000/05/08
Date: Tue, 14 Sep 2010 23:55:54 -0400

Mike Johnston wrote:
> I've tried both VARYBINBIND AND BINARYBIND neither work.

Something is broken in that neighborhood. No unit test used those
bindings. I modified dblib/unittests/t0007.c and got:

dblib.c:7189:copy_data_to_host_var(56 [SYBINT4] len 4 => 45 [SYBBINARY]
len 4)
dblib.c:7319:copy_data_to_host_var(): tds_convert returned 4
dblib.c:7189:copy_data_to_host_var(47 [SYBCHAR] len 12 => 45 [SYBBINARY]
len 1024)
convert.c:303:error_handler: attempt to convert data stopped by syntax
error in source field
dblib.c:7319:copy_data_to_host_var(): tds_convert returned -3
dblib.c:7880:dbperror(0x8055000, 20050, 0)
dblib.c:7932:20050: "Attempt to convert data stopped by syntax error in
source field"

That's as far as I got. I committed the changes to let someone else look
into why.

--jkl

Re: [freetds] Pulling Blobs from SQL Server 2000/05/08, James K. Lowden, 09/14/2010
- Re: [freetds] Pulling Blobs from SQL Server 2000/05/08, Frediano Ziglio, 09/15/2010