CODEWITHSUNDEEP
.netsql-serverlinuxsslwine
Михаил Анохин
Михаил Анохин

Reputation: 11

Linux + Wine can not connect to SQL Server by System.Data.SqlClient with error about handshake in provider: SSL Provider, error: 0 - SSL provider

i have a windows forms app (.net framework 4.0), that connect to SQL Server by System.Data.SqlClient. I'd like to use this provider. I can connect by Odbc, but in my program may be too hard to change main provider, so i'd like to stay with System.Data.SqlClient.

Everything works fine in Windows, but when I try to use Linux with Wine I get error

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - SSL provider: )

I had installed in my wine (and framework ofcourse)

winetricks mdac28 native_mdac

and odbc provider in my Linux I use Ubuntu 20.04, but got same error in other Debian like version I use SQL Server 2016, installed on Windows 2016. No enforce encryption enabled in SQL Server.

I read that Wine cannot set SSL connections to SQL Server, but I have no idea, how I can avoid it, and have no idea, why it try to use it, against I don't use SSL encryption at all. Could you give me advise, what I can do to avoid this error and establish connection.

Upvotes: 0

Views: 1522

Answers (1)

Ivan
Ivan

Reputation: 1

Just ran into this myself with another application, even when using unencrypted connections set by string.

Found a suggestion in the WINE bugs tracker to set an override for secur32.dll to native. This worked for my application.

Upvotes: 0

Related Questions