[Bug 56738] New: ODBC stopped working in Wine 9.9, it works fine in 9.8

[WineHQ Bugzilla]

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

Bug ID: 56738
           Summary: ODBC stopped working in Wine 9.9, it works fine in 9.8
           Product: Wine
           Version: unspecified
          Hardware: x86-64
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P2
         Component: odbc
          Assignee: [e-mail]
          Reporter: [e-mail]
      Distribution: ---

Created attachment 76517
  --> https://bugs.winehq.org/attachment.cgi?id=76517
WINEDEBUG logs

After updating my Arch linux install from wine 9.8-2 to wine 9.9-2 my 32bit
applications using multilib unixodbc stopped working.

I tried WINEDEBUG=+odbc but could get much relevant output.
Most interesting is probabaly this: trace:odbc:SQLAllocEnv Returning 309,
EnvironmentHandle 00000000

WINEDLLOVERRIDES="odbc32=b" or "odbc=b" didn't change anything as far as I can
tell.

If I downgrade the package it immediately starts connecting again.

The driver I use is the proprietary SQL Anywhere 17 odbc driver.
It works fine using unixodbc with both linux x86_64 and linux 32 bit
applications.

Is there any way I can provide more relevant information?

Attached is a trace of +odbc when it works, and when it doesn't.

[Bug 56738] ODBC stopped working in Wine 9.9, it works fine in 9.8

[WineHQ Bugzilla]

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

Fabian Maurer  changed:

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

--- Comment #1 from Fabian Maurer  ---
There have been big changes to odbc handling in 9.9.

Can you compile wine from source and do a regression test? See
https://wiki.winehq.org/Regression_Testing

Second best would be clear instructions on how to test the issue, including
downloads.

[Bug 56738] ODBC stopped working in Wine 9.9, it works fine in 9.8

[WineHQ Bugzilla]

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

--- Comment #2 from Hans Leidekker  ---
Error 309 corresponds to STATUS_DLL_NOT_FOUND. Note that if you were setting
LIB_ODBC_DRIVER_MANAGER then you'll need to use an alternative now, like
LD_PRELOAD.

[Bug 56738] ODBC stopped working in Wine 9.9, it works fine in 9.8

[WineHQ Bugzilla]

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

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|unspecified                 |9.9

[Bug 56738] ODBC stopped working in Wine 9.9, it works fine in 9.8

[WineHQ Bugzilla]

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

--- Comment #3 from [e-mail] ---
Created attachment 76641
  --> https://bugs.winehq.org/attachment.cgi?id=76641
Init script for SQLAnywhere

(In reply to Hans Leidekker from comment #2)

That is a great tip. I have added an attachment for the SQLAnywhere
initialization script. Before just setting LD_LIBRARY_PATH seemed to be enough.

I'll look into it next week.

Thanks.