Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

# dialog.dll issues

troels@arvin.dk posted 4 years ago in Creating a connection
I'm trying to log into a MariaDB database on a remote system using HeidiSQL 9.2.0.4947 (64 bit) on a workstation with Windows 8.1. The database is PAM integrated.

When I try to log in, I'm told that "Authentication plugin 'dialog' cannot be loaded: Det angivne modul blev ikke fundet." The latter part of the error message is in Danish, and it translates to "The indicated module was not found".

HeidiSQL resides in C:\Program Files\HeidiSQL, and it has a subdirectory called "plugins" which contains a file "dialog.dll". Using SpyStudio, I traced what happened and saw that dialog.dll was being looked for in C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin instead of in C:\Program Files\HeidiSQL\plugins. So I created a directory structure C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin containing only one file, namely the dialog.dll file copied from C:\Program Files\HeidiSQL\plugins. And then things work.

Looking at the trace from SpyStudio, it seems that the dll load was being handled by libmysql. So maybe HeidiSQL needs to add its own C:\Program Files\HeidiSQL\plugins directory to the paths which are being searched when looking for dialog.dll. Or maybe there's a bug in the libmysql which HeidiSQL bundles?

By the way: When running the exact same HeidiSQL version on Linux, using Wine, I don't have any issues; so maybe there's something about the dll search mechanisms in Windows 8.1 which makes HeidiSQL fail to load dialog.dll?