Skip to Content.
Sympa Menu

freetds - Re: TDS support matrix (was RE: [freetds] tsql problem)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: TDS support matrix (was RE: [freetds] tsql problem)
  • Date: Thu, 13 Mar 2003 17:21:48 -0500 (EST)


To say MS SQL ever supported 5.0 is a bit misguided I'm afraid. The
extent of support was basically, it would accept a TDS 5.0 login packet
and then tell the client to fall back to 4.2. This was basically because
the 4.2 and 5.0 login packets were largely the same. I frankly would
avoid even attempting to send 5.0 to MS SQL as it will likely re-break at
some point in the future (like when they remove 4.2 support down the
road).

You seek something like this:

+---------------------------------------------------------------+
| | MS SQL | Sybase ASE | Sybase ASA |
+---------------------------------------------------------------+
|ver |6.5 |7.0 |2000| <10.x | >11.0 |<5.5.03|5.5*|>6.0|
+-----+----+----+----+-----------+------------+-------+----+----+
| 4.2 | X | X | X | X | X | | | |
| 5.0 | | | | | X | | X | X |
| 7.0 | | X | X | | | | | |
| 8.0 | | | X | | | | | |
+-----+----+----+----+-----------+------------+-------+----+----+

* Sybase ASA 5.5 requires 5.5.03 or better with the OpenServer Gateway
(OSG).

Cheers,

Brian

On Thu, 13 Mar 2003, Craig A. Berry wrote:

> At 3:05 PM -0500 3/13/03, Lowden, James K wrote:
>
> >The matrix you seek is in the UG http://www.freetds.org/userguide/x574.htm.
> >I mean that to be comprehensive and accurate. I see it's not: it implies
> >but doesn't state that 4.2 is available on all servers (except ASA). I
> >think I'll add a column to Table 3-1 indicating alternatives.
>
> Thanks, James. I'd seen that table and it certainly has part, but
> not all, of what I mean. It sort of gives the "favorite" TDS version
> for each product (or the new version introduced by the product)
> rather than all supported versions. For example, there's no way to
> find out from there that TDS 5.0 support was present in MS SQL Server
> 6.x, broken in 7.0, reintroduced in 7.0 SP2, and officially
> discontinued in SQL 2000. I suppose this information could be added
> to the comments column, or perhaps there could be a column called
> "unsupported TDS versions" since knowing what versions will not work
> with any given server may be as helpful as knowing which ones will
> work.
>




Archive powered by MHonArc 2.6.24.

Top of Page