Menu
I've been using FreeTDS with 8.0 protocol for some time to connect to a MSSQL Database, and things have worked great. But, recently, things started to not work so great. I'll spare the details.
So we decided we needed to know a bit more, and I am a bit confused by the following:
Does FreeTDS support Microsoft servers?
Yes. Microsoft servers don't usually accept TDS 5.0 connections. Use one of versions 4.2, 7.0 or 8.0 of the protocol. See the User Guide for details.
User Guide
[No mention of 8.0 anywhere on the page.]
So, what is TDS Protocol Version 8.0 and why should I use it?
970
The Tabular Data Stream (TDS) Protocol is an application-level protocol used for the transfer of requests and responses between clients and database server systems. In such systems, the client will typically establish a long-lived connection with the server.
Tabular Data Stream (TDS) is a protocol, or a set of rules describing how to transmit data between two computers. Like any protocol, it defines the types of messages that can be sent, and the order in which they may be sent. Protocols describe the "bits on the wire", specifying how data flows.
TDS depends on Transport Layer Security (TLS)/Secure Socket Layer (SSL) for network channel encryption. Although the TDS protocol depends on TLS/SSL to encrypt data transmission, the negotiation of the encryption setting between the client and server and the initial TLS/SSL handshake are handled in the TDS layer.
FreeTDS "version 8" is actually version 7.1. Unfortunately, you have to look at the "history of TDS versions" page to figure that out, but here's the explanation from there:
Earlier FreeTDS documentation referred to versions 7, 8 and 9. Microsoft subsequently published a protocol specification document denoting 7.1 and 7.2, and one finds scattered references using that scheme elsewhere, too. For that reason, FreeTDS switched to Microsoft's nomenclature.
144
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
