MS SQL ODBC 17驱动程序首先连接tme，但随后给出SSL提供程序错误:140A90F1:lib(20)：func(169)：reason(241)

Question

我面临着这个问题与dotNET核心应用程序，连接和断开与SQL server使用odbc.ini中定义的DSN。目前我使用的是最新的UnixODBC驱动程序，即msodbcsql17-17.4.2.1-1和unixODBC驱动程序unixODBC 2.3.7。

我也曾尝试将MSSQL ODBC驱动程序降级到11和13，但都不起作用。

我从odbc.ini获得的当前DSN设置如下：

[ICMDB]
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.2.1
Server = 10.32.7.145
Port = 1433
User = user
Password = password
Database = inst3_sideA
Language = us_english

和日志文件包含以下错误：

2020-01-05 05:07:50.541 [T:9 P:17003] [FATAL] dbconnectivity.dbconnectivity ODBC Connected with Failure with connection string DSN=ICMDB;UID=qauser;Pwd=Password1;
System.Data.Odbc.OdbcException (0x80131937): ERROR [08001] [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:140A90F1:lib(20):func(169):reason(241)]
ERROR [08001] [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()

提前感谢！

Answer 1

幸运的是，我在同一天和同一个IP上也观察到了同样的问题。您当前安装的mysql odbc驱动程序是8.0.19，没有向后兼容性。将你的mysql odbc驱动程序降级到8.0.17，然后看看它是没有错误的。:)