When running a simple multi-table query with CASE WHEN statements, Heidi Crashes. Any ideas why?
Multi-Step Operation Generated Errors
Yes, this is a known issue - see issue #423. Do you know how to circumvent such errors?
Sorry, not something I've seen before.
I can however see why I'm only now experiencing it though. I've had messages when opening Heidi and connecting to a server using SQLOLEDB about security and prompting me to download the MSOLEDBSQL Driver which is more secure.
It is this Driver which is causing the issue. I've switched back to the less secure SQLOLEDB and the same query works fine.
Please login to leave a reply, or register at first.