Re: Pulling Blobs from SQL Server 2000/05/08

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