WineHQ
Category: Main Productivity Database HeidiSQL HeidiSQL 10.1

HeidiSQL

No Screenshot

Submit Screenshot

From https://www.heidisql.com/ about version 10.1 release:

This is a new release which mainly fixes the installer, which named the executable in your program files folder "heidisql32.exe", not "heidisql.exe". Sounds minor, but I suppose there are quite a few links out there still pointing to heidisql.exe. The 10.1 installer now deletes that heidisql32.exe and installs the fresh heidisql.exe.

Application Details:

Version: HeidiSQL 10.1
License: Free to use
URL: http://www.heidisql.com
Votes: 0
Latest Rating: Gold
Latest Wine Version Tested: 4.1

Maintainers: About Maintainership

Free Download Download HeidiSQL

Test Results

Old test results
The test results for this version are very old, and as such they may not represent the current state of Wine. Please consider submitting a new test report.
Selected Test Results

What works

Almost everything. It installs, it runs. You can connect to database servers, browse tables, modify data, modify tables. Update user permissions. Store multiple profiles for multiple servers. Export results. Save and load sql snippets. Everything I tried works with one exception: see notes below on crash when running custom query against MSSQL server.

What does not

Program crashes when running custom queries against MSSQL only. You can run custom queries against other databases just fine, it is only

Microsoft sql server. I don't know why, and I have not been able to find a workaround. There is a wine bug report for this specific problem. This is the only thing I know of that does not work.

Workarounds

Must install mdac28 and set native_mdac via winetricks. Optionally you can install corefonts via winetricks (sh winetricks corefonts) or fonts will be a bit odd looking.

If you want to avoid the crash when running custom query against MSSQL database, try wine version 3.14. This problem does not occur with that version. Wine versions 3.15 and cause various crashing problems.

What was not tested

Nothing that I can think of - I've been using this program for a long time, and I ran it through its paces. I use it almost every day. I'm

sure there are some obscure bugs in it, but I did everything I could think of.

Hardware tested

Graphics:

  • GPU: Intel
  • Driver: proprietary

Additional Comments

I give it a SILVER rating because of the above mentioned crash. There is no workaround that I am aware of other than to use an older wine version.

This report is primarily for version 10.1. However, the crashing problem described above happens to version 9.5 and 10.0 of HeidiSQL as well.

I tested every version of wine from 3.0 through 4.1.

With wine versions 3.0 through 3.14, this program works perfectly. Starting with wine 3.15 and above, including 4.0 and 4.1, there are various crashing problems.

selected in Test Results table below
Operating systemTest dateWine versionInstalls?Runs?Used
Workaround?
RatingSubmitter
CurrentSlackware64 14.2 multilibFeb 04 20194.1Yes Yes YesGoldZootal 

Known Bugs

Bug # Description Status Resolution Other apps affected

Show all bugs

Comments

The following comments are owned by whoever posted them. WineHQ is not responsible for what they say.

Wine 5.x breaks HeidiSQL MSSQL connectivity.
by Zootal on Wednesday February 26th 2020, 12:29
It appears something in wine 5.x is breaking connectivity with MSSQL server. I had to revert back to wine 4.21 to get it to work. I will post more details when I have a chance, and I will be opening a bug report with Wine about this issue. For now, if you are getting crashes trying to access MSSQL database, try reverting your wine version back to 4.x.
RE: Wine 5.x breaks HeidiSQL MSSQL connectivity.
by Zootal on Wednesday February 26th 2020, 12:32
PS the crash reported in my test results above and the associated Wine bug report was fixed in a later Wine version. Sadly, wine is broken again effective version 5.x.
Back