What is this TDS protocol in Sybase?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is this TDS protocol in Sybase?

Tabular Data Streams or TDS is the name given to the protocol that is used to connect Sybase clients with Sybase servers. A specification for the protocol can be obtained from Sybase, I had a copy but cannot seem to find it now.

The is a project that is reverse engineering the protocol and building a set of libraries independent of either Sybase or Microsoft, but able to connect to either of their servers. FreeTDS is a considerable way down the line, although I do not believe that it is production ready yet!

(Continued on next question...)

Other Job Interview Questions

• What is ASA UltraLite in Sybase?
• What is the difference between an LTM and a RepAgent in Sybase?
• What will cause the size of a stored procedure to grow in Sybase?
• How can I improve throughput in Sybase?
• What is my identity burn factor vulnerability right now in Sybase?
• Fixing a Munged Log in Sybase ?
• How do I set a password to be null?
• How Do I Choose Which Tables To Partition in Sybase?
• Optimizing your home grown Sequential key generating process for any version of Sybase
• How do I Configure the burn factor in Sybase?
• More...