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: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • 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:25:44 +0100

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

=================================


Attachment: bcpforbill.zip
Description: Binary data




Archive powered by MHonArc 2.6.24.

Top of Page