Cannot create connection to MS SQL Server on Linux

I try to connect with HeidiSQL 11.0.0.5919 on Linux (Ubuntu 20.04) to a local SQL Server running in Docker. When I try to switch the connection type to "Microsoft SQL Server (TCP/IP)" HeidiSQL crashes.

See attached bug report.

Is that reproducible?

You could update to the latest Heidi build and retry.

Wine version may also be the cause here.

Yes, it is reproducable.

I tried with the latest nightly build with the same result.

Wine is the current version of Ubuntu 20.04.

BTW, switching to PostgreSQL works fine.

Perhaps update Wine? I don't know which version is the current one for Ubuntu, but there may be a newer Wine out there?

MSSQL is the only connection type in HeidiSQL which goes through the ADO libraries. On Windows, you normally also need to make sure to have the latest VC redistributable from https://support.microsoft.com/en-us/help/3179560/update-for-visual-c-2013-and-visual-c-redistributable-package . Probably that helps.

I just wanted to add that I also have this issue. I have:

Debian 10.6 HeidiSQL 11.1.0.6116 wine-5.21

If I select any network type other than the MS SQL Server ones there are no issues, but if I select any SQL Server it crashes.

I'm not sure what this means or if it's helpful, but wine showed this when it crashed:

• 02c8:fixme:msado15:recordset_QueryInterface interface {00000283-0000-0010-8000-00aa006d2ea4} not implemented
• 02d4:fixme:wtsapi:WTSQuerySessionInformationW Stub 0000000000000000 0xffffffff 10 00000000029CF330 00000000029CF32C
• 02d4:fixme:ntdll:NtQuerySystemInformation info_class SYSTEM_PERFORMANCE_INFORMATION

I tried updating the VC Redistributable from this page:

https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads

to the one in the "Visual Studio 2015, 2017 and 2019" section, but HeidiSQL still crashed. Is that the right one?

I also tried updating the one from the link you post (2013) and still got the crash.

Probably install winetricks:

wget http://winetricks.org/winetricks
chmod +x winetricks
sh winetricks mdac28
sh winetricks native_mdac

I tried those commands. I got quite a few errors/warnings about 32-bit vs 64-bit versions. I tried this:

winetricks prefix=wine32 mdac28 winetricks prefix=wine32 native_mdac

and that made the errors go away. However, when I tried to select MS SQL again in HeidiSQL it crashed. Is there anything else I could try?