Cannot create connection to MS SQL Server on Linux

ralfmr's profile image ralfmr posted 4 years ago in Creating a connection Permalink

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.

1 attachment(s):
ansgar's profile image ansgar posted 4 years ago Permalink

Is that reproducible?

You could update to the latest Heidi build and retry.

Wine version may also be the cause here.

ralfmr's profile image ralfmr posted 4 years ago Permalink

Yes, it is reproducable.

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

Wine is the current version of Ubuntu 20.04.

ralfmr's profile image ralfmr posted 4 years ago Permalink

BTW, switching to PostgreSQL works fine.

ansgar's profile image ansgar posted 4 years ago Permalink

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.

raphael75's profile image raphael75 posted 4 years ago Permalink

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.

raphael75's profile image raphael75 posted 4 years ago Permalink

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
raphael75's profile image raphael75 posted 4 years ago Permalink

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?

raphael75's profile image raphael75 posted 4 years ago Permalink

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

ansgar's profile image ansgar posted 4 years ago Permalink

Probably install winetricks:

wget http://winetricks.org/winetricks
chmod +x winetricks
sh winetricks mdac28
sh winetricks native_mdac
raphael75's profile image raphael75 posted 4 years ago Permalink

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?

Please login to leave a reply, or register at first.