Skip to Content.
Sympa Menu

freetds - RE: [freetds] bcp uniqueindentifier (was: replication & bcp)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Dickens <mike.dickens AT tbred.co.uk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] bcp uniqueindentifier (was: replication & bcp)
  • Date: 10 Feb 2004 10:22:28 +0000

wonderfull!! that worked a treat.

thank you,
mike.

On Mon, 2004-02-09 at 22:58, Lowden, James K wrote:
> > From: Lowden, James K
> > Sent: February 9, 2004 3:17 PM
> > > From: Michael Dickens [mailto:mike.dickens AT tbred.co.uk]
> > > Sent: February 9, 2004 1:39 PM
> > >
> > > i'm trying to use freebcp to copy data to sql server. everything was
> > > fine 'til the tables were replicated which put a new field of type
> > > 'uniqueindentifier' on the end of each table. just putting a
> > > blank field
> > > on the end of each line worked on ms bcp, but on freebcp it gave the
> > > error:
> > > 'Expected the TEXT token in the data stream for bulk copy of text or
> > > image data'
> >
> > Confirmed. The freebcp of FreeTDS 0.62.1 does not upload
> > uniqueindentifier data, even NULL uniqueindentifier data. I
> > don't know why, but I will look into it.
>
> I think the attached will make you happier. I used it to upload a
> uniqueidentifier field with freebcp. I haven't tried to apply it to the
> 0.62 branch yet.
>
> --jkl
>
>
> -----------------------------------------
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above. If you are not the intended recipient, or an employee or agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible for carrying
> out such orders and/or instructions.
> If you, as an intended recipient of this commercial e-mail or
> advertisement, would not like to receive further e-mail correspondence from
> the sender, please "reply" to the sender indicating your wishes.
> In the U.S.: 1345 Avenue of the Americas, New York, NY 10105
>
>
>
>
> ______________________________________________________________________
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page