Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Pulling Blobs from SQL Server 2000/05/08
  • Date: Wed, 15 Sep 2010 11:55:35 +0200

2010/9/15 James K. Lowden <jklowden AT freetds.org>

> 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




Archive powered by MHonArc 2.6.24.

Top of Page