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

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

[WineHQ Bugzilla]

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

--- Comment #6 from [e-mail] ---
The issue still exists in Wine 10.11
The list of ODBC connections in the Windows version of SQL Anywhere Interactive
SQL now is completely empty, so maybe there is another issue in play here.

I cannot test at the moment since I cannot get the application i need to start
in a wow64 wine prefix. So I would first need to recompile with win32 support.
In the mean time I downgraded to 9.8 and it works fine.