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

2010/9/15 James K. Lowden <[email protected]>

> 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
>

VARYBINBIND is not supported. This require additional code for conversion.
libTDS does not support DBVARYCHAR. About BINARYBIND... good catch... I
don't know exactly proprietary library behavior...

freddy77