Skip to Content.
Sympa Menu

freetds - Re: [freetds] freebcp row termination not working on freebcp into MSSQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freebcp row termination not working on freebcp into MSSQL
  • Date: Wed, 2 Nov 2005 13:13:26 -0000

It should work with just the -c option, regardless of the version.
take a look at your data file, using 'od' perhaps, to see what's
*really* terminating the row.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
bpollard AT micron.com
Sent: 02 November 2005 00:13
To: freetds AT lists.ibiblio.org
Subject: [freetds] freebcp row termination not working on freebcp into
MSSQL



> My freebcp -v is
> freebcp version $Id: freebcp.c,v 1.34.2.1 2005/02/03 09:39:14 freddy77
> Exp $
>
> Error I get with this command (it does not delimit my rows naturally
> with carriage return or when I designate -r \n:
>
> freebcp temp_bcp..seg_threshold_stats_bcp in /var/tmp/audit_thresh.bcp
> -c -b 10 -U$my_user -P$my_pwd -SBOMSSDEVL19:1433
>
> Starting copy...
>
> Msg 4803, Level 16, State 1
> Server 'NTSQL12\BOMSSDEVL19', Line 1
> Received invalid row length 30976 from bcp client. Maximum row
> size is 479.
> Msg 20018, Level 5
> General SQL Server error: Check messages from the SQL Server.
>
> -Brian
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------



  • Re: [freetds] freebcp row termination not working on freebcp into MSSQL, Thompson, Bill D (London), 11/02/2005

Archive powered by MHonArc 2.6.24.

Top of Page