Question about TDS Version (build, interfaces, env)
camber at ais.org
Mon Jun 4 18:21:38 EDT 2001
Actually I had big plans but got tied up dealing with the domain stuff
(about to check in the new configuration stuff maybe tommorow). So, just
email the new version when done and I'll check it in en masse.
On Mon, 4 Jun 2001, Lowden, James K wrote:
> Brian, I'll look after this. You have modified the UG you grabbed from the
> website, right? I'll fix my copy of userguide.sgml tonight and send you a
> Gotta admire a guy who defines "bug" as "does not behave as documented".
> Bonus question: If there's no documentation, is that zero, one, or more
> -----Original Message-----
> From: Brian Bruns [mailto:camber at ais.org]
> Sent: June 4, 2001 5:04 PM
> To: TDS Development Group
> Subject: [freetds] Re: Question about TDS Version (build, interfaces,
> Found a bug! The documentation doesn't agree with the code...argh, it does
> explain why someone had such a devil of a time setting the version in the
> interfaces file though...Thank you, Darryl.
> The proper form for the interfaces file is "4.2", it's just that all the
> documentation is wrong! Any recent CVS version will take either "42" or
> "4.2" for the environment variable.
> As far as the search order goes it's: environment variable, interfaces
> file, and lastly compile time default.
> Need to fix the doc...
> On Mon, 4 Jun 2001, Darryl Friesen wrote:
> > Brian Bruns gave a wonderful explanation of the problems and possible
> > solutions for selecting large text fields. I'm hoping Brian (or anyone)
> > provide an equally wonderful explanation of where any how to set the TDS
> > version FreeTDS will use to talk to the server.
> > My understanding is there's 3 places this can be defined:
> > 1. At compile time, using --with-tdsver=(4.2, 4.6, 5.0, or 7.0)
> > This is only used when one of the other methods is not, is
> > that correct?
> > 2. Using the TDSVER environment variable. The example in the User
> > Guide shows a value of "42", not "4.2" like above. Is that
> > correct; no period?
> > 3. In the interfaces file as the third field on the line. Do the
> > values specified here match the ones at build? ie 4.2, 4.6, 5.0
> > or 7.0. I've seen Usenet/web postings that indicate the value
> > here should be something like "tds4.2" instead of "4.2" or "42".
> > Which is correct? See:
> > http://www.phpbuilder.com/mail/php-db/2000072/0440.php
> > Which takes precidence, 2 or 3?
> > The reason I'm asking all this is that I'm having trouble with strings
> > longer than 255 characters AND with TEXT fields. It seems like I need to
> > sure I'm using TDS 7.0 to talk to my SQL server, but I'm not sure I have
> > settings in the interfaces file or the environement set correctly.
> > I originally compiled FreeTDS using --with-tdsver=4.2, but have the
> > interfaces file and environment set to 7.0. However, I'm seeing the same
> > type of truncation mentioned when using the 4.2 protocol, and recompiling
> > using --with-tdsver=7.0 causes my Perl/DBI script no end of trouble ("Out
> > memory during large request" errors).
> > - Darryl
More information about the FreeTDS