[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.

[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 #4 from Hans Leidekker  ---
Do you still see with current Wine?

[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 #5 from [e-mail] ---
Sorry for not digging further into this yet.

I still get the problem on archlinux: wine-9.22-1

Rolling back to 9.8-2 and it works fine again.

I think I will wait for Wine 10 to arrive and check again. As soon as I find
the time I can check if the libraries are loaded correctly. But currently I
don't have time to debug it, sorry.

There is a Developer Trial version of SQLAnywhere at:
https://www.sqlanywhere.info/EN/sql-anywhere/download.html if the binaries are
needed.