FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

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/
--------------------------------------------------------