SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,958 questions
How to fix "error:1C80006B:Provider routines::wrong final block length" in SQL Server ODBC client (Linux)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Tim Coleman
0
Reputation points
I'm trying to write C++ ODBC driver code to execute SQL statements from a Linux server.
I keep running into errors such as:
DIAG [08S01] [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1C80006B:Provider routines::wrong final block length] DIAG [08S01] [Microsoft][ODBC Driver 18 for SQL Server]Communication link failure
This only seems to happen with encrypted connections.
SQL Server
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,757 questions
{count} votes
-
Jack J Jun 24,516 Reputation points Microsoft Vendor2024-10-03T04:54:06.8566667+00:00 @Tim Coleman, Welcome to Microsoft Q&A, could you provide the related C++ code about how to execute SQL statements from a Linux server, especially your connection string? Based on my research, if you set
TrustServerCertificate=yesin your connection string, it may help you solve the problem. -
Tim Coleman 0 Reputation points
2024-10-03T16:46:47.8933333+00:00 No, I have that already.
-
Jack J Jun 24,516 Reputation points Microsoft Vendor
2024-10-04T01:13:21.29+00:00 @Tim Coleman, thanks the response, do you mean that you have solved the problem or your connection string contains
TrustServerCertificate=yes? -
Tim Coleman 0 Reputation points
2024-10-04T15:04:39.7366667+00:00 What I mean is that the problem is not solved, and the connection string does contain TrustServerCertificate=yes.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 57.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Minxin Yu 11,996 Reputation points Microsoft Vendor2024-10-07T07:53:57.5933333+00:00 Are you connecting to Linux SQL server from Windows? Can you provide a minimal reproducible code example?
-
Tim Coleman 0 Reputation points
2024-10-07T13:48:08.4366667+00:00 No, it is a connection from Linux.
-
Minxin Yu 11,996 Reputation points Microsoft Vendor
2024-10-08T07:47:04.34+00:00 For C++ part, you could refer to C / C++ ODBC example application accesses an SQL database:
https://learn.microsoft.com/en-us/sql/connect/odbc/cpp-code-example-app-connect-access-sql-db?view=sql-server-ver16
Sign in to comment
Sign in to answer