freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
- To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] bcp broken on TDS 5.0
- Date: Fri, 23 Apr 2004 11:24:31 +0100
it *MAY* not be freeTDS that's (generically) problematic, it *MAY* be ASE
12.5
The bcp data sent down the wire to a Sybase server is an image of a row as
it is physically stored within the database
It may well be that Sybase have changed how row data is stored in 12/12.5
...and that therefore our bcp data is being misinterpreted by the server.
SQL server on the other hand sends a bcp data stream in the known TDS ROW
message format, the server taking care of inserting the data into the
tables....
Bill
> -----Original Message-----
> From: James K. Lowden [SMTP:jklowden AT schemamania.org]
> Sent: 23 April 2004 03:14
> To: TDS Development Group
> Subject: [freetds] bcp broken on TDS 5.0
>
> I'm connected to:
>
> Adaptive Server Enterprise/12.5.1/EBF 11429/P/Linux Intel/Enterprise
> Linux/ase1251/1823/32-bit/OPT/Tue Sep 16 23:43:54 2003
>
> And it doesn't look good for the unit test:
>
> $ ./bcp
> found alex.FreeTDS for jklowden in "../../../PWD"
> Start
> About to logon
> About to open alex.FreeTDS
> Dropping alex.FreeTDS..all_types_bcp_unittest
> Creating alex.FreeTDS..all_types_bcp_unittest
> preparing to insert into FreeTDS..all_types_bcp_unittest ... OK
> Sending same row 10 times...
> Msg 4837, Level 16, State 5
> Server 'test', Line 1
> Bad row data received from the client while bulk copying into object
> 32000114 in database 4. Received a row of length 85 whilst maximum or
> expected row length is 24950.
>
> OK
>
> ^C
>
> "whilst"? Never let it be said Sybase wasn't written by geeks. Sixteenth
> century geeks at that.
>
> --jkl
>
>
> _______________________________________________
> 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/>
==============================================================================
-
[freetds] bcp broken on TDS 5.0,
James K. Lowden, 04/22/2004
- Re: [freetds] bcp broken on TDS 5.0, Michael Peppler, 04/23/2004
- <Possible follow-up(s)>
-
RE: [freetds] bcp broken on TDS 5.0,
Thompson, Bill D (London), 04/23/2004
- Re: [freetds] bcp broken on TDS 5.0, James K. Lowden, 04/24/2004
- RE: [freetds] bcp broken on TDS 5.0, Thompson, Bill D (London), 04/26/2004
- RE: [freetds] bcp broken on TDS 5.0, Lowden, James K, 04/26/2004
- RE: [freetds] bcp broken on TDS 5.0, Thompson, Bill D (London), 04/26/2004
-
RE: [freetds] bcp broken on TDS 5.0,
Thompson, Bill D (London), 04/26/2004
- Re: [freetds] bcp broken on TDS 5.0, James K. Lowden, 04/26/2004
- Re: [freetds] bcp broken on TDS 5.0, James K. Lowden, 04/26/2004
- RE: [freetds] bcp broken on TDS 5.0, Lowden, James K, 04/26/2004
Archive powered by MHonArc 2.6.24.