FreeTDS Development Group

["Eric Deutsch" <edeutsch AT systemsbiology.org>]

> -----Original Message-----
> From: bounce-freetds-127899 AT franklin.oit.unc.edu
> [mailto:bounce-freetds-127899 AT franklin.oit.unc.edu]On Behalf Of James K.
> Lowden
>
> Hi Eric,
>
> Thanks for taking the time to document what you found.  I think
> you gave me some things
> to add to the Known Issues.
>
> Eric Deutsch wrote:
>
> > freetds.conf.pl appears to be identical to
> README.freetds.conf.pl instead
> > of a perl script.  Might be just TODO or possibly CVS checkin issue.
>
> Or just a bleary-eyed goof.  Please try again; I think it will
> look more like perl to
> you now.

great, thanks.

> > when I do "SELECT @@TEXTSIZE" under SQL 2000, I get 64512 as a default.
>
> Is that the documented default size, BTW?  Under 7.0, the docs
> say TEXTSIZE defaults to
> 4096, but the behavior is to report 4 GB.

Yes or maybe, sort of.  Here is an exerpt straight from the on-line docs for
8.0:

...
}Remarks
}The default size is 4096 bytes.
}
}Examples
}This example uses SELECT to display the @@TEXTSIZE value before and after
it is changed with the SET TEXTSIZE statement.
}
}SELECT @@TEXTSIZE
}SET TEXTSIZE 2048
}SELECT @@TEXTSIZE
}
}Here is the result set:
}
}------------------------
}64512
}
}------------------------
}2048
...

So the claim is that the default is 4096, but whose default, maybe not Query
Analyzer's?  The example strongly implies that the default may be 64512,
which is what I get when I do SELECT @@TEXTSIZE in Query Analyzer.  However,
when I do a SELECT @@TEXTSIZE from a FreeTDS client, I get 2147483647.  I
have not tested to see whether a resultset really does get limited to 64512
in QA.  I know it doesn't get limited to 4096.  So I'm guessing that Query
Analyzer sets the default to 64512 when it opens a connection.  How a
FreeTDS client gets a default of 2147483647 is unclear to me; that number is
the theoretical maximum, implying to limitation was imposed (which is not
crazy).  How 4096 is a default then for anything is unclear (maybe that bit
of text in the docs hasn't been touched since 6.5).  I have no answers, but
I'm warming up to the idea of setting @@TEXTSIZE at the beginning of a
connection; it seems like the thing to do.


> > Otherwise, FreeTDS is great, I use it every day!
>
> Still soliciting case studies, you know.  Yours could be one.  :)

I don't think our case is very interesting or "big", we have two servers and
a handful of clients all rather uniformly using Linux + Perl DBI + MSSQL
2000, and we're really just ramping up our use of FreeTDS in a "production"
sense.  But if you don't mind a small-time case, I can write a few
paragraphs.

thanks,
Eric


> Regards,
>
> --jkl
>
>
> ---
> You are currently subscribed to freetds as: [edeutsch AT systemsbiology.org]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>