[Bug 42998] New: OLE error with HeidiSQL trying to access Microsoft Sql Server

https://bugs.winehq.org/show_bug.cgi?id=42998

Bug ID: 42998
           Summary: OLE error with HeidiSQL trying to access Microsoft Sql
                    Server
           Product: Wine
           Version: 2.7
          Hardware: x86-64
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P2
         Component: -unknown
          Assignee: [e-mail]
          Reporter: [e-mail]
      Distribution: ---

Created attachment 58139
  --> https://bugs.winehq.org/attachment.cgi?id=58139
Screen shot of error

HeidiSQL version 9.4.0.5169
Using Slackware 14.2 64 bit.

With Wine 2.6 and 2.7, when trying to access a MS SQL database, you get an OLE
error. See attachment for screen shot. This works just fine with Wine 2.5.

Steps to reproduce:

1) Use a clean wine prefix!
2) Run the installer - it will install just fine.
3) Run the app. Try to connect to a MSSQL database. It will complain about mdac
not installed, as it should.
4) winetricks mdac_28 - DO THIS WHILE THE APP IS STILL RUNNING, DON'T TERMINATE
THE APPLICATION (not sure if this matters, it is just how I did it)
5) Try your MSSQL database access again, note that it works.
6) Terminate application.
7) Run application again, and from this point on it will give you an error, and
you will no longer be able to connect.

This appears in the console:

err:ole:CoGetClassObject class {6c736db1-bd94-11d0-8a23-00aa00b58e10} not
registered
err:ole:CoGetClassObject no class object {6c736db1-bd94-11d0-8a23-00aa00b58e10}
could be created for context 0x1
fixme:comsvcs:DllGetClassObject
({ecabb0c0-7f19-11d2-978e-0000f8757e2a},{00000001-0000-0000-c000-000000000046},0x33f37c)
stub
err:ole:apartment_getclassobject DllGetClassObject returned error 0x80040111
err:ole:CoGetClassObject no class object {ecabb0c0-7f19-11d2-978e-0000f8757e2a}
could be created for context 0x1
fixme:comsvcs:DllGetClassObject
({ecabb0c0-7f19-11d2-978e-0000f8757e2a},{00000001-0000-0000-c000-000000000046},0x33f31c)
stub
err:ole:apartment_getclassobject DllGetClassObject returned error 0x80040111
err:ole:create_server class {ecabb0c0-7f19-11d2-978e-0000f8757e2a} not
registered
fixme:ole:CoGetClassObject CLSCTX_REMOTE_SERVER not supported
err:ole:CoGetClassObject no class object {ecabb0c0-7f19-11d2-978e-0000f8757e2a}
could be created for context 0x17

Again, note that this is Wine 2.6 and 2.7 ONLY, it works fine with Wine 2.5

[Bug 42998] OLE error with HeidiSQL trying to access Microsoft Sql Server

https://bugs.winehq.org/show_bug.cgi?id=42998

Austin English  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |regression

--- Comment #1 from Austin English  ---
Please run a regression test:
https://wiki.winehq.org/RegressionTesting

[Bug 42998] OLE error with HeidiSQL trying to access Microsoft Sql Server

https://bugs.winehq.org/show_bug.cgi?id=42998

--- Comment #2 from [e-mail]  ---
I'll see if I can do it tomorrow, might have to wait until the weekend. Either
way I'll do it.

[Bug 42998] OLE error with HeidiSQL trying to access Microsoft Sql Server

https://bugs.winehq.org/show_bug.cgi?id=42998

Alistair Leslie-Hughes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #3 from Alistair Leslie-Hughes  ---
No a regression, but rather a missing feature.

Before installing mdac28, set mtxdm to native.

[Bug 42998] OLE error with HeidiSQL trying to access Microsoft Sql Server

https://bugs.winehq.org/show_bug.cgi?id=42998

--- Comment #4 from Matthew Reed  ---
Taadaa!! Setting mtxdm to native appears to do the trick, even with existing
wine prefixes.

I'm not sure how to classify this bug report. Is this a bug, something missing
from Wine? I'm not in the dev loop, so don't really know what to do with this
bug report at this time.

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

Alistair Leslie-Hughes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
            Summary|OLE error with HeidiSQL     |HeidiSQL requires
                   |trying to access Microsoft  |IDispenserManager
                   |Sql Server                  |implementation.
             Status|UNCONFIRMED                 |NEW
           Keywords|regression                  |

--- Comment #5 from Alistair Leslie-Hughes  ---
comsvcs.dll needs to provide an implementation of the IDispenserManager
interface.

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

Alistair Leslie-Hughes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|-unknown                    |comsvcs

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

Austin English  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #6 from Austin English  ---
(In reply to Alistair Leslie-Hughes from comment #3)
> No a regression, but rather a missing feature.
>
> Before installing mdac28, set mtxdm to native.

winetricks currently sets:
odbc32 odbccp32 oledb32 to native,builtin

I can add mtxdm as well. Does that sound okay?

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

--- Comment #7 from Alistair Leslie-Hughes  ---
(In reply to Austin English from comment #6)
> (In reply to Alistair Leslie-Hughes from comment #3)
> > No a regression, but rather a missing feature.
> >
> > Before installing mdac28, set mtxdm to native.
>
> winetricks currently sets:
> odbc32 odbccp32 oledb32 to native,builtin
>
> I can add mtxdm as well. Does that sound okay?

Yes. That would be great.

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

--- Comment #8 from Austin English  ---
(In reply to Alistair Leslie-Hughes from comment #7)
> (In reply to Austin English from comment #6)
> > (In reply to Alistair Leslie-Hughes from comment #3)
> > > No a regression, but rather a missing feature.
> > >
> > > Before installing mdac28, set mtxdm to native.
> >
> > winetricks currently sets:
> > odbc32 odbccp32 oledb32 to native,builtin
> >
> > I can add mtxdm as well. Does that sound okay?
>
> Yes. That would be great.

https://github.com/Winetricks/winetricks/commit/c9e0a5ee5821d54fe6ff0d50989c...

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

--- Comment #9 from Matthew Reed  ---
I grabbed the latest winetricks from winetricks/src on github. Created a new 32
bit prefix. winetricks mdac28. I can confirm that this does in deed work. Thank
you everyone!

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

Matthew Reed  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #10 from Matthew Reed  ---
Setting status to RESOLVED-FIXED. This issue was fixed in Winetricks as noted
in the comments.

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

Austin English  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|FIXED                       |---
             Status|RESOLVED                    |REOPENED

--- Comment #11 from Austin English  ---
(In reply to Matthew Reed from comment #10)
> Setting status to RESOLVED-FIXED. This issue was fixed in Winetricks as
> noted in the comments.

Thanks for testing. As Alistair pointed out though, there's some a wine bug to
fix.

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

Alistair Leslie-Hughes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
      Fixed by SHA1|                            |9b9b4c0dda66f4f950df489bb98
                   |                            |2b2ebbc4bbc31
             Status|REOPENED                    |RESOLVED
         Resolution|---                         |FIXED

--- Comment #12 from Alistair Leslie-Hughes  ---
Fixed by
https://source.winehq.org/git/wine.git/?a=commit;h=9b9b4c0dda66f4f950df489bb...

[Bug 42998] HeidiSQL requires IDispenserManager implementation.

https://bugs.winehq.org/show_bug.cgi?id=42998

Alexandre Julliard  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #13 from Alexandre Julliard  ---
Closing bugs fixed in 3.15.