Skip to Content.
Sympa Menu

freetds - RE: [freetds] nulls cause data errors with bcp out

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] nulls cause data errors with bcp out
  • Date: Thu, 23 Jan 2003 12:26:39 -0000

cheers freedy, that's a real help!

> -----Original Message-----
> From: ZIGLIO Frediano [SMTP:Frediano.Ziglio AT vodafoneomnitel.it]
> Sent: 23 January 2003 11:26
> To: 'freetds AT lists.ibiblio.org'
> Subject: RE: [freetds] nulls cause data errors with bcp out
>
> >
> > Thanks James,
> >
> > I'm having a look at bcp at the moment, so I'll take a look
> > at your changes
> > and verify.
> > FYI, I'm implementing the -e flag (error file) functionality
> > at the moment,
> > along the lines we discussed a while ago.
> > I'll also implement the -m (max errors) flag on freebcp
> > I'm trying to get blob data working on bcp in to sql server
> > 7/2000 as well,
> > although I'm struggling a bit.
> >
> > Does anyone have the wherewithal to do a network sniff for
> > me. It might take
> > me a couple of days to do this myself...
> >
> > I want to see what the MS version of bcp sends to the server in the
> > following scenario:
> >
> > assuming table <DB>..<test_text_bcp> ( col1 int, col2 text )
> >
> > and an input file containing :
> >
> > 1 abcdefghijklmnop
> >
> > and the command:
> >
> > bcp <DB>..<test_text_bcp> in <filename> -c -S... -U... -P...
> >
> > thanks,
> >
> > Bill
> >
>
> Hi Bill.
> Here it is!
> SQL w2k (test db and account).
> Is in tcpdump format (captured with ethereal)
>
> freddy77
>
> =================================
> "STRICTLY PERSONAL AND CONFIDENTIAL
>
> This message may contain confidential and proprietary material for the
> sole
> use of the intended recipient. Any review or distribution by others is
> strictly prohibited. If you are not the intended recipient please contact
> the sender and delete all copies.
> The contents of this message that do not relate to the official business
> of
> our company shall be understood as neither given nor endorsed by it."
>
> =================================
>
> << File: bcpforbill.zip >>





Archive powered by MHonArc 2.6.24.

Top of Page