MS SQL Server - Supported TDS versions in SQL 2005

Author

Supported TDS versions in SQL 2005

Dejan Markic

2006-01-29, 7:23 am

Hello all!

I'm migrating from SQL 2000 to SQL 20005 and everything works OK, but I need
to connect to SQL also from Linux machines and I use FreeTDS for that.
It works great with SQL 2000 and TDS Version set to 80, but I cannot connect
to SQL 2005, it sais that the TDS version (80) I try to connect with is not
supported.
Here's the full message I see in event log:

The Tabular Data Stream (TDS) version 0x80000000 of the client library used
to open the connection is unsupported or unknown. The connection has been
closed. [CLIENT: 192.168.9.170]

Can I enable womehow the TDS version 80 in SQL 2005? FreeTDS does not
support the 90 version yet ...

Please help!

Thank you and kind regards,
Dejan
--

Dan Guzman

2006-01-29, 9:23 am

> Can I enable womehow the TDS version 80 in SQL 2005? FreeTDS does not
> support the 90 version yet ...

If you must use FreeTDS, it looks like you need to be patient. For the
longer term, you might consider converting to JDBC. The 2005 driver is
currently in beta
(http://www.microsoft.com/technet/pr.../jdbc.mspx#EFAA).

Depending on your application, Native XML Web services might be another
option. See the SQL Server 2005 Books Online
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ed5c0445-1534-4373-9616-c8e5a1663479.htm)
for more information.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Dejan Markic" <dejan@akton.is> wrote in message
news:lj2Df.318$76.190139@news.siol.net...
> Hello all!
>
> I'm migrating from SQL 2000 to SQL 20005 and everything works OK, but I
> need to connect to SQL also from Linux machines and I use FreeTDS for
> that.
> It works great with SQL 2000 and TDS Version set to 80, but I cannot
> connect to SQL 2005, it sais that the TDS version (80) I try to connect
> with is not supported.
> Here's the full message I see in event log:
>
> The Tabular Data Stream (TDS) version 0x80000000 of the client library
> used to open the connection is unsupported or unknown. The connection has
> been closed. [CLIENT: 192.168.9.170]
>
> Can I enable womehow the TDS version 80 in SQL 2005? FreeTDS does not
> support the 90 version yet ...
>
> Please help!
>
> Thank you and kind regards,
> Dejan
> --
>
>

Alan Brewer [MSFT]

2006-01-30, 8:23 pm

The SQL Server 2005 JDBC driver has now been released:

http://msdn.microsoft.com/data/jdbc/default.aspx

I've asked our Web coordinator to update the technet page.

--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team

SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/

This posting is provided "AS IS" with no warranties, and confers no rights.

Dejan Markic

2006-01-31, 3:23 am

I do not use Java, so that does not help much. I use PHP to connect to
MSSQL, any other protocols/libraries available?

Thanks for your answers!

Kind regards,
Dejan
--

"Alan Brewer [MSFT]" <alanbr@microsoft.com> wrote in message
news:%23hmg9EgJGHA.528@TK2MSFTNGP12.phx.gbl...
> The SQL Server 2005 JDBC driver has now been released:
>
> http://msdn.microsoft.com/data/jdbc/default.aspx
>
> I've asked our Web coordinator to update the technet page.
>
> --
> Alan Brewer [MSFT]
> Content Architect, SQL Server Documentation Team
>
> SQL Server Developer Center: http://msdn.microsoft.com/sql
> SQL Server TechCenter: http://technet.microsoft.com/sql/
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>

Sponsored Links