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: wine-bugs@winehq.org Reporter: claudius+wine@hausnetz.lettenbach.com 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.
https://bugs.winehq.org/show_bug.cgi?id=56738
Fabian Maurer dark.shadow4@web.de changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |dark.shadow4@web.de
--- Comment #1 from Fabian Maurer dark.shadow4@web.de --- 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.
https://bugs.winehq.org/show_bug.cgi?id=56738
--- Comment #2 from Hans Leidekker hans@meelstraat.net --- 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.
https://bugs.winehq.org/show_bug.cgi?id=56738
Ken Sharp imwellcushtymelike@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Version|unspecified |9.9
https://bugs.winehq.org/show_bug.cgi?id=56738
--- Comment #3 from claudius+wine@hausnetz.lettenbach.com --- 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.
https://bugs.winehq.org/show_bug.cgi?id=56738
--- Comment #4 from Hans Leidekker hans@meelstraat.net --- Do you still see with current Wine?
https://bugs.winehq.org/show_bug.cgi?id=56738
--- Comment #5 from claudius+wine@hausnetz.lettenbach.com --- 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.
http://bugs.winehq.org/show_bug.cgi?id=56738
--- Comment #6 from claudius+wine@hausnetz.lettenbach.com --- 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.