What connection string parameters are relevant to resolving 'Protocol error in TDS stream' issues with ODBC Driver 17?

Responsive Ad Header

Question

Grade: Education Subject: Support
What connection string parameters are relevant to resolving 'Protocol error in TDS stream' issues with ODBC Driver 17?
Asked by:
118 Viewed 118 Answers

Answer (118)

Best Answer
(557)
Key parameters include: `Server` (server name or IP address), `Database` (database name), `UID` (username), `PWD` (password), `Driver` (the driver name), `Encrypt` (e.g., 'Yes', 'No', or 'Optional' to control encryption), `TrustServerCertificate` (needed with `Encrypt=Yes` if the server certificate isn't trusted), `Port` (if the server isn't using the default port), `Network Library` (specifying the network protocol - TCP/IP, named pipes, etc.), and `Connection Timeout`. Carefully review the combinations and values used to resolve connectivity issues.