Linux: Slackware current, 64 bit, 4.19.18 kernel. Wine version 4.0 32 bit clean prefix with nothing installed but mdac28 (cause Heidisql won't talk to mssql server at all without that).
This is a variation on the mdac problem with MSSQL server. I can setup the server just fine:
Network type: Microsoft SQL Server (TCP/IP)
I can open it, I see my databases, I see the tables. I can click on a table, click the data tab, and see my data. This works. Heidisql is obviously accessing the SQL server and retrieving data. I can even update data by typing the updates into the data grid.
If I select the Query tab and type in a custom query, just something simple like select * from <some table>, an error occurs:
exception number : 1 exception class : EDatabaseError exception message : Recordset is not open.
main thread ($9): 0084556a heidisql32.r5473.exe Data.DB DatabaseError 7eab02e5 user32.dll DispatchMessageW 7eae759e user32.dll GetParent 7b42ba79 KERNEL32.dll GlobalFindAtomW
And you get the message about installing mdac28, which is already installed.