Re: MS Tabular Data Stream (TDS)
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 02/27/04
- Previous message: New2SQLServer: "MS Tabular Data Stream (TDS)"
- In reply to: New2SQLServer: "MS Tabular Data Stream (TDS)"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 27 Feb 2004 14:16:39 -0700
SQL Server itself uses TDS as an application level protocol
for communication between a client and the server.
Per books online, the communication process is:
TDS packets are built by the Microsoft OLE DB Provider for
SQL Server, the SQL Server ODBC driver, or the DB-Library
DLL. The TDS packets are then passed to a SQL Server client
Net-Library, which encapsulates the TDS packets into network
protocol packets. On the server, the network protocol
packets are received by a server Net-Library that extracts
the TDS packet and passes it to the relational database
server.
This process is reversed when results are returned to the
client.
-Sue
On Fri, 27 Feb 2004 12:06:05 -0800, "New2SQLServer"
<New2SQLServer> wrote:
>Can someone tell me what this is: MS Tabular Data Stream (TDS)?
>I looked in the manuals, but I still don't quite get it. On one hand, it
>looks like an engine level API that puts data into packets on the wire,
>but on another diagram it looked like it was part of the Client/Server
>comm flows and just there. It says it is supported in ODBC and OLEDB.
>What about .Net? Do people use it? Is it that much fater? help?
- Previous message: New2SQLServer: "MS Tabular Data Stream (TDS)"
- In reply to: New2SQLServer: "MS Tabular Data Stream (TDS)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
