Multi-Step Operation Generated Errors

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

When running a simple multi-table query with CASE WHEN statements, Heidi Crashes. Any ideas why?

1 attachment(s):
  • HeidiBug-2019-07-29
ansgar's profile image ansgar posted 5 years ago Permalink

Yes, this is a known issue - see issue #423. Do you know how to circumvent such errors?

aSystemOverload's profile image aSystemOverload posted 5 years ago Permalink

I do not, is there a post? Can't see anything about circumventing on the Tracker.

ansgar's profile image ansgar posted 5 years ago Permalink

No I was asking for a workaround. I don't have one currently, but I'd like to fix that issue.

aSystemOverload's profile image aSystemOverload posted 5 years ago Permalink

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.