Cannot find a usable libmariadb.dll.

shulato's profile image shulato posted 5 years ago in General Permalink

When I open HeidiSQL

Cannot find a usable libmariadb.dll. Please launch heidisql.exe.backup.exe from the directory where you have installed it

ansgar's profile image ansgar posted 5 years ago Permalink

I assume this was an outdated version. Please use the latest build, and just start it using the icon in your start menu or from the taskbar.

fariha's profile image fariha posted 5 years ago Permalink

how to fix it?

1 attachment(s):
  • Capture
ansgar's profile image ansgar posted 5 years ago Permalink

fariha, the message says it.

You can also install a newer build, from the nightly builds section on the download page. They have a new "Library" selector in the session settings.

fariha's profile image fariha posted 5 years ago Permalink

i solve it.. then i did not add the heidisql.exe in their own folder.. now its working after adding this exe. thank you......

Reinald's profile image Reinald posted 3 years ago Permalink

Hi Ansgar,

I seem to face a similar issue as described here before. I already installed the newest update. Do you have an idea how to fix this?

Thank you very much.

1 attachment(s):
  • 2020-12-30_191314
ansgar's profile image ansgar posted 3 years ago Permalink

Same thing as above: you probably have heidisql.exe in some folder, but not in the one where the other required dll files are located (e.g. C:\Program Files\HeidiSQL)

remcolam's profile image remcolam posted 3 years ago Permalink

I have the same thing. I installed heidisql on a new machine, all default options, shortcut shows that the working folder is C:\Program Files\HeidiSQL, executable is in that folder, libmariadb.dll is in that folder. ALso running directly from that folder doesn't work.

Only choosing libmysql.dll works, the other two do not work.

VC++ redistributable was also installed.

remcolam's profile image remcolam posted 3 years ago Permalink

PS, latest general release: 11.1.0.6116

(version 10.3 same thing actually).

Please note, this was one a fresh new Windows 10 VM, with nothing else installed on it yet

ansgar's profile image ansgar posted 3 years ago Permalink

@remcolam and you get the same error message like above? ("internal error 126: module was not found")

remcolam's profile image remcolam posted 3 years ago Permalink

So I ran dependency walker on the dll, It is missing the vc runtime 140 dll, which is from VC++ 2015. You can find it on the microsoft site. (Can't post a link to it yet)

Installing that will fix it. I would suggest this get's included in the installer or at the very least gets mentioned on the download page

remcolam's profile image remcolam posted 3 years ago Permalink

@ansger So yes, I got the exact same error. The issue is of course that was a minty fresh machine, nothing else installed... My other develop machine has visual studio installed and tons of other apps, so probably the redistributable got on the machine already there.

(So I can't post the link because I don't have enough posts yet)

remcolam's profile image remcolam posted 3 years ago Permalink

@ansgar (oops, wrong mention... see above post)

Reinald's profile image Reinald posted 3 years ago Permalink

I already had vcruntime140.dll [14.12.25810.0] included in C:\Windows\SysWOW64 on Windows 10 when I received the error message three days ago.

I now downloaded vcruntime140.dll [14.28.29304.1] from https://www.dllme.com/dll/files/vcruntime140_dll.html and put it into Heidis program folder. There is a new error message:

2 attachment(s):
  • 2021-01-02_120622
  • 2021-01-02_115628
remcolam's profile image remcolam posted 3 years ago Permalink

SysWow64 is the 32 bit folder. If you are are running 64 bit HeidiSQL, that would have been the wrong one. The other message is just that you database is not reachable, try telnet locahost 3306 to see if you can actually connect, but I suspect what you are running into now is no longer a HeidiSQL issue

Reinald's profile image Reinald posted 3 years ago Permalink

Thank you all. Finally the error was due to a new login rule of my host (domainfactory). Tunnelling is no longer possible via SSH but using the socket. The tunnel (on Win 10) is now established via cmd and Heidi works fine as ever.

maroonmike's profile image maroonmike posted 3 years ago Permalink

I have the same thing. I installed heidisql on a new machine, all default options, shortcut shows that the working folder is C:\Program Files\HeidiSQL, executable is in that folder, libmariadb.dll is in that folder. ALso running directly from that folder doesn't work.

Only choosing libmysql.dll works, the other two do not work.

VC++ redistributable was also installed.

Thanks for this! I had the same issue on a new Windows 10 build. Installing the Microsoft Visual C++ 2015 (x64) Redistributable corrected the problem for me as well. I am using the HeidiSQL 64 bit version.

umurkaragoz's profile image umurkaragoz posted 3 years ago Permalink

Had the same issue on my new machine; Windows 10 build 1909 - 18363.1350 HeidiSQL 11.2.0.6213 (x64)

I had "internal error 126: module was not found" on my error message.

Installing Microsoft Visual C++ 2015 solved my issue.

I'd like to take this chance to thank you @ansgar for this amazing software!

eyedmax's profile image eyedmax posted 3 years ago Permalink

Same here: libmariadb.dll and libmysql-6.1.dll demand msvc++ 2015, but there is no mention about it in Heidi.

Installing it solved the problem.

ansgar's profile image ansgar posted 3 years ago Permalink

I already planned to include a VC runtime in the next installer release. See issue #1296. I'm just not sure which one is the latest (2015?)

pantantrollo's profile image pantantrollo posted 3 years ago Permalink

I already planned to include a VC runtime in the next installer release. See issue #1296. I'm just not sure which one is the latest (2015?)

You can include (or show a note) the Microsoft Visual C ++ Redistributable package for Visual Studio 2019, which is backwards compatible 2015 and 2017

https://support.microsoft.com/en-us/topic/the-latest-supported-visual-c-downloads-2647da03-1eea-4433-9aff-95f26a218cc0

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