freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: John Kendall <john AT capps.com>
- To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
- Subject: [freetds] bcp/datacopy bit columns TDS 5.0
- Date: Fri, 9 May 2014 19:58:43 +0000
I'm using Sybase (TDS 5) and am running into a problem using datacopy (from
0.91) when a table has more than one bit column.
The problem is easy to reproduce:
create table tempdb..bob (bit1 bit, bit2 bit)
insert tempdb..bob values (1,0)
$ datacopy -c dbo -S SRV/usr/pw/tempdb/bob -D
SRV/usr/pw/tempdb/bob2
Msg 4837, Level 16, State 2
Server 'SRV', Line 1
Bad row data received from the client while bulk copying
into object 1328007762 in database 2. Received a row of length 4 while
maximum possible row length is 3.
Msg 4837, Level 16
General SQL Server error: Check messages from the SQL Server
bcp_done failed.
datacopy: table copy failed.
the data may have been partially copied into the target
database
I searched the archives and found this thread:
"bcp currently broken for BIT type in TDS 5.0"
https://lists.ibiblio.org/sympa/arc/freetds/2006q4/020788.html
I couldn't find anything more about it. I realize it was almost 8 years ago,
but does anyone have any more info?
-
[freetds] bcp/datacopy bit columns TDS 5.0,
John Kendall, 05/09/2014
-
Re: [freetds] bcp/datacopy bit columns TDS 5.0,
James K. Lowden, 05/16/2014
- Re: [freetds] bcp/datacopy bit columns TDS 5.0, Frediano Ziglio, 05/17/2014
-
Re: [freetds] bcp/datacopy bit columns TDS 5.0,
James K. Lowden, 05/16/2014
Archive powered by MHonArc 2.6.24.