FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

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.
>