does not start the connection

doing a clean install

running heidisql.exe 10.2.0.5608 i create a new connection, and try to connect and the window just closes.

systeminfo: OS Name: Microsoft(R) Windows(R) XP Professional x64 Edition OS Version: 5.2.3790 Service Pack 2 Build 3790

PS. heidisql.exe 9.5.0.5459 works without problems. removed portable_settings.txt and all without changes, how can I start the debug mode?

Was the v10.1 working for you?

I recall I updated the database dlls for v10.1, but no update between 10.1 and 10.2, so it may be some different cause.

You can activate debug messages in the console, in Preferences > Logging. In the session manager click on the "More" button to get to the preferences window.

HeidiSQL 10.1.0.5580 64 Bit, not working.

How can a console be useful? if it appears after connecting to the server? so it is impossible to understand why the connection did not start. there are no errors in the operating system logs.

and 10.1.0.5560 also not working.

HeidiSQL_10.0.0.5460 it works.

Yes, of course, you can see the console only when the connection started successfully. But you could also enable writing session logs to file, in the log preferences. Then, after a failed connection, you could watch the latest log file from

C:\Users\<yourUsername>\AppData\Roaming\HeidiSQL\Sessionlogs\

Hopefully this sheds some light into this issue. Don't forget we are talking about Windows XP, which is very old. And yes, HeidiSQL aims to still support it, but doing so is getting more and more difficult.

OK, I've enabled the console but I don't see any startup errors in the reports, see the attached file. Is it possible to increase the debug level? Yes, Windows XP is old, I'm probably the only one who still uses it :). If the problem can not be solved, you can write that with version 10.1 XP support is discontinued.

You are using one of the themes. These raised many problems already. I'd recommend turning that setting back to "Windows" (Session manager > More > Preferences)

It's definitely not in the themes. the windows theme also does not start.

If you run version 10.0.0.5460, disconnect from all servers. close the window and run for example version 10.2.0.5609 then we will be able to see the Session manager window. when you try to open a session, everything is closed.

See the session start

For narrowing it even more down to a specific version, you could please try out the following builds (just place them besides your existing heidisql.exe and run them):

• https://www.heidisql.com/builds/heidisql32.r5464.exe (v10.1 release)
• https://www.heidisql.com/builds/heidisql32.r5466.exe (with new high resolution icons)

404 - executable for r5464 not found 404 - executable for r5466 not found

Ah shit I cleaned up the build folders recently...

Well, in the meantime I could reproduce such a sudden app termination myself, while connecting to an old MySQL 4.0 server. The crash went away after deleting/renaming libmariadb.dll, so I only had libmysql.dll in the HeidiSQL folder. Please do the same to check if that helps. If yes, you hit issue #697.

deleted libmariadb.dll, no change. brought back and deleted libmysql.dll, also unchanged. I think the problem lies elsewhere, otherwise there would be no entry in the records of the session on successful SQL query.

I use connect to mysql 5.6.44

I suspect your logfile to contain more after that SHOW DATABASES line, unless HeidiSQL was unable to finish writing to that logfile. Could you check that in your log file?

heidisql 10.2.0.5614 libmysql.dll

heidisql 10.2.0.5614 libmysql.dll

heidisql 10.2.0.5614 libmariadb.dll log file 000013.log - 0 byte

This is quite problematic, if the log file is not updated at the end for some reason.

Please update again to the latest build. I have just pushed some changes which at least should show a more detailed message when using libmariadb. Also try libmysql again. And be sure to use the dlls from the last official release 10.2.

I use:

• heidisql32.r5616.exe - 8 240 695 bytes
• heidisql64.r5616.exe - 9 103 415 bytes
• libmariadb.dll E46FACF134CCB3C6C04F196E9C717F58 - 1 025 448 bytes
• libmysql.dll 8AD4DA6DD06F1DEA86EFF2129B2A2B38 - 183 296 bytes

1. Run heidisql32.r5616.exe + libmariadb.dll = Library libmariadb.dll could not be loaded. Please select a different one. Internal error 193: %1 is not a valid Win32 application
2. Run heidisql32.r5616.exe + libmysql.dll = Library libmysql.dll could not be loaded. Please select a different one. Internal error 193: %1 is not a valid Win32 application
3. Run heidisql64.r5616.exe + libmariadb.dll =

• The procedure entry point InitOnceExecuteOnce could not be located in the dynamic link library KERNEL32.dll.
• Library libmariadb.dll could not be loaded. Please select a different one. Internal error 127: The specified procedure could not be found

4. Run heidisql64.r5616.exe + libmysql.dll = no errors and window closes.

Session not started. not write session.log

So you installed the 64 bit version and tried the 32bit lib's which of course fail to load. So far so normal. Now, while my libmariadb.dll has the same size as yours, your 64bit libmysql.dll has a different size than mine:

• yours: 183 296 bytes
• mine: 4 747 776 bytes

You could update libmysql.dll from the 64 bit portable zip.

good updated and used libmysql.dll (4 747 776 bytes). window closes. Session not started. see 000002.log

Ok, after that last half written log line, there is normally this one:

Restoring tab setup from C:\Users\<username>\AppData\Roaming\HeidiSQL\tabs.ini

The path is probably only valid on Win10, and Win7 probably, but on XP it's probably such one:

C:\Documents and Settings\<yourusername>\Application Data\HeidiSQL\tabs.ini

I suspect the restore-tabs feature to fail because the folder cannot be located or written to for some reason. Please look at the path if it exists.

Ah and you could disable that restore-feature, in the session manager > More > Preferences > Files > "Reopen previously used ..."

File tabs.ini found in C:\Documents and Settings\Administrator\Application Data\HeidiSQL Yes if I disable the option "Reopen previously used SQL files and unsaved content in tabs *", session starts successfully.

can be use system variable "APPDATA" ?

• XP 64 C:>set | find "APPDATA" APPDATA=C:\Documents and Settings\Administrator\Application Data

• Vista,W7,W8,W10 64 C:>set | find "APPDATA" APPDATA=C:\Users\Administrator\AppData\Roaming

thanks, great job.

strangely, the library selection is not saved for the connection, although it is suggested to save the changes. and puts all time libmariadb.dll

Did you press the "Save" button to save the library change?

The directory is what I expected on XP, and you say tabs.ini is there, so I wonder why HeidiSQL crashes when accessing it. Probably because it cannot create the subfolder "Backups" there - is it there?

C:\Documents and Settings\Administrator\Application Data\HeidiSQL\Backups\

And is there any .sql file in it?

Yes, I pressed save. Folder exists C:\Documents and Settings\Administrator\Application Data\HeidiSQL\Backups\ but files in it there is no

Ok, I think I am going to disable the restore/store feature when the tabs.ini cannot be written.

how to determine the cause of cannot be written?

you should probably write in the report, it is impossible to write for the reason: insufficient rights (for example, the folder has a read-only attribute)

You could again update to the latest build, which now disables the tab re/store feature when writing tabs.ini fails. Of course you need to activate that again through preferences > Files.

By the way, thanks a lot for your quick testing and feedback.

updated (HeidiSQL 10.2.0.5618 64 Bit) and set on "Reopen previously used SQL files and unsaved content in tabs *" Run connection, window closes session not started.

Hm, shit.

Did you or could you check if you can manually make changes to that tabs.ini file? And if no, why you have no access to it?

changes write I can, just in case I deleted the whole folder C:\Documents and Settings\Administrator\Application Data\HeidiSQL, as the file were references to nonexistent files .sql, in the hope that the application will create because of the new folder and files. but only the folder is created C:\Documents and Settings\Administrator\Application Data\HeidiSQL it is empty.

I also noticed this oddity, if you change the setting "Reopen previously used SQL files and unsaved content in tabs *" and the session does not start, the settings are not saved. you need to open the settings from the beginning to change then close the application, then the settings are saved.

if unset "Reopen previously used SQL files and unsaved content in tabs *", application running normaly and starting session.