Table Data Stream protocol (TDS)

Source: Internet
Author: User

TDS is a protocol that describes how data is transmitted between two computers. Like other protocols, it defines the types of transmission information and their transmission order. In short, the Protocol describes "online BITs", that is, how data flows. The table data stream protocol is based on TCP/IP net-library and is included in the TCP Data Segment. TDS uses port 1433 for database communication.

The TDS protocol is located in the TCP Data Segment and has the following structure:

IP TCP TDS Header Data Segment of TDS

8-bit Header

The TDS client uses a dedicated SQL Server application called table format data stream (TDS ).ProgramLevel protocol to send SQL statements. Data packets are generated by Microsoft ole db provider for SQL Server, SQL Server ODBC driver, or DB-library DLL. TDS data packets are then transmitted to the SQL Server Client net-Library. The client net-library encapsulates the TDS data packets as network protocol data packets. On the server, the server net-Library receives network protocol data packets and analyzes and transmits the data packets to the relational database server. When the result is returned to the client, the process is executed in reverse mode.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.