FreeTDS Development Group

["Huckle, Steve" <steve.huckle AT csfb.com>]

Hey James,

Thnx for the info....didn't have time to check through the source code, but
I have dug around a little, & yup you're right, many of the functions are
incomplete.

Anyways, yeah sparc big-endian, but no, I can't get *any* uploads to
work....core dump every time.....hohum %(  But then I don't have any idea
about the far end in all honestly....I'll enquire after SP3...what did it
'fix'?

But I'll have to admit, I'm using BCP 'cause I'm a newby and couldn't get
something like $dbh->sql("insert......") to work.... 

Rgds,

Steve Huckle 

-----Original Message-----
From: James K. Lowden [mailto:jklowden AT speakeasy.org]
Sent: 30 April 2001 23:24
To: TDS Development Group
Subject: [freetds] RE: Solaris 7, freetds, [dbd::Sybase || sybperl ]


"Huckle, Steve" wrote:

> Hi,
>
> Yeah, I can get reads running, but not writes (using BCP)....they core
dump.
>

Oh.  BCP did you say?  Oh my.

One of my roundtuit projects is to make BCP way better.  With all due
respect (I mean
that) to the author, it's incomplete and not particularly obvious about it,
until you
look at the source code.  Many functions simply return "success" without
doing
anything.

Many features are missing.  Transactions and writes from memory (not a file)
are two
that come to mind immediately.

Also, SQL Server 7.0 introduced many subtle changes (witness discussions
here about
endians and  dates, null bits, wide varchars) to the TDS, and it's likely
that some
of the fixes were "alongside" the BCP code.

If you're doing single-transaction uploads from a file to a table containing
long-established (pre 7.0) datatypes -- and you've applied SP3 to your
server to
address date endian problems (because yours is a Solaris client, doesn't
that mean
Sparc, big-endian?) -- then BCP uploads will probably work.  Outside those
parameters, I'd bet against it.

Glad to hear someone else *cares* about BCP.  Might raise my motivation,
although the
weather is getting better, too.

HTH.

--jkl


---
You are currently subscribed to freetds as: [steve.huckle AT csfb.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')

This message is for the named person's use only.  It may contain 
confidential, proprietary or legally privileged information.  No 
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. CREDIT SUISSE GROUP and each of its subsidiaries each reserve
the right to monitor all e-mail communications through its networks.  Any
views expressed in this message are those of the individual sender, except
where the message states otherwise and the sender is authorised to state 
them to be the views of any such entity.
Unless otherwise stated, any pricing information given in this message is 
indicative only, is subject to change and does not constitute an offer to 
deal at any price quoted.
Any reference to the terms of executed transactions should be treated as 
preliminary only and subject to our formal written confirmation.