Skip to Content.
Sympa Menu

freetds - Re: [freetds] dbbind funny

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] dbbind funny
  • Date: Fri, 11 Jun 2004 18:30:28 -0400

On Fri, 11 Jun 2004, "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
wrote:
> > There's another bugaboo in this neighborhood that'd be nice to fix.
> > When freebcp encounters a data conversion error, its most common
> > message is 20073 (Attempt to bulk-copy a NULL value).
> > What's happening is that dbconvert() fails, meaning that destlen is 0,
> >
> > causing the "converted" data to be nil, which is then sent to the
> > server.
>
> > The server obviously sees zero-length data as null, and complains.
> > Unless the column is nullable, that is, in which case you, er, merely
> lose your data.
>
> Not any more, my friend.
> A conversion error is now reported as such.
> The "Attempt to bulk-copy a NULL..." message now only occurs in genuine
> circumstances.
> In neither case do the rows of data get anywhere near the server...

Have I mentioned lately how very much I like you? I look forward to your
patch.

I think I'll be quiet for a while and write some documentation or
something....

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page