FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

I guess I'll weigh in on this one.  text types are working with TDS
versions 4.2/5.0.  There seems to be a problem with text types under 7.0
from the reports I've seen (a possible work around might be to cast it
to a nvarchar(?) dunno).  Anyway, it is very possible that MS changed
behaviour under 7.0 and we are the victim of it.  I never tested it, since
I'm primarily a Sybase user.

Secondly, there is a problem with large queries under TDS 7.0 (large
meaning greater than the block size (512 bytes - overhead)). I've
requested network traces of a successful large query (win32 client) from
people on the list, but haven't yet received any.  I'm not adverse to
setting up a test and running it myself but I'm a busy person and
frankly I'm not the one having the bug so it's not high on my list. ;-) 

The third thing I'm aware of is problems with insert/update queries.
Reports have been from MS SQL users, but I'm not sure if this is a TDS 7
bug or whether it extends to 4.2/5.0 and sybase as well.

Lastly, we have Michaels intermittant error hitting MS SQL which I am
currently working on. I also have a second report of this one on Sybase
Anywhere, so it is not MS specific.

There may be more than that, I'm terrible about keeping lists.  If anyone
wants to 'own' these bugs and do the necessary leg work to get them fixed
I'm more than happy to fix them.  But what usually happens (and not
singling anyone out here, just a general statement), is the bug gets
reported, I'll request a few things (network traces, etc...) and I never
get them. 

Sorry for the rant.

Brian

On Mon, 2 Oct 2000, Michael Kimsal wrote:
> I missed a few messages (and probably can't help anyway!)
> but what's the problem?  We're using text types with little problem.
> The problems I have seem to be more related to the size of the query
> string in general rather than data type, as far as I can see.
> Short answer - the longer the query string, the more likely it
> is the process will hang.  Not scientific I know, but it's all I can
> see so far.
> 
> Mind you, our 'text' fields are still generally under 10k - I haven't tried 
> them
> holding >10k, so that may be where the problem is.
> 
> Can you get text fields to work at all?
> 
> 
> 
> >
> > ----- Original Message -----
> > From: "Sebastian Enders" <enders AT comvos.de>
> > To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
> > Sent: Monday, October 02, 2000 9:38 AM
> > Subject: [freetds] Re: FreeTDS and text data type
> >
> > > > On Mon, 2 Oct 2000, Sebastian Enders wrote:
> > > >
> > > > > Nobody has an idea how to patch the freetds to work fine with text
> > > > > data types in TDS version 7.0????
> > > >
> > > > 1. Have you looked through the mailing list archives?
> > > Yes of course, nobody discussed this problem.
> > >
> > > > 2. Have you pulled down the latest version of the code?
> > > Yes i did, it doesn?t work either. :-(
> > >
> > > Everything works fine, but text data types doesn?t work.
> > > I saw that few people have had the same problem, and they couldn?t fix 
> > > it
> > > or managed it either.
> > >
> > > Perhaps you have an idea?
> > >
> > > Would be very nice!
> > >
> > > Best regards,
> > > Sebastian
> > >
> > > ---
> > > You are currently subscribed to freetds as: [vapesa AT hotmail.com]
> > > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> > >
> >
> > ---
> > You are currently subscribed to freetds as: [michael AT tapinternet.com]
> > To unsubscribe, forward this message to 
> > leave-freetds-12294M AT franklin.oit.unc.edu
> 
> --
> ==========================
> Michael Kimsal
> http://www.tapinternet.com
> 734-480-9961
> 
> 
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to 
> leave-freetds-12294M AT franklin.oit.unc.edu
>