https://bugs.winehq.org/show_bug.cgi?id=46235
Bug ID: 46235 Summary: Opening ADODB.Connection results in: Method '~' of object '~' failed Product: Wine Version: 3.18 Hardware: x86 OS: Linux Status: UNCONFIRMED Severity: normal Priority: P2 Component: -unknown Assignee: wine-bugs@winehq.org Reporter: bugs@seeitmyway.org Distribution: ---
Created attachment 62931 --> https://bugs.winehq.org/attachment.cgi?id=62931 VB6 example program
Hello
I've been battling with this for four days now and found no solution, yet it worked a year ago.
Opening an ADODB.Connection in wine fails with this message: Method '~' of object '~' failed
Yet it works fine in Windows (XP).
In essence, the program does only this: Dim cn As ADODB.Connection Set cn = New ADODB.Connection cnStr = "DRIVER={MySQL ODBC 5.3 UNICODE Driver};" _ & "SERVER=localhost;" _ & "DATABASE=db;" _ & "UID=user;" _ & "PWD=password;" _ & "PORT=3306;" _ & "POOLING=false;" _ & "OPTION=3;" cn.ConnectionString = cnStr Call cn.Open ' <--- fail
Quick steps to reproduce: 1. Download: - https://downloads.mysql.com/archives/get/file/mysql-connector-odbc-5.3.6-win... - Attached sample VB6 program I compiled.
2. Run: WINEARCH="win32" WINEPREFIX="$HOME/wine-ado" ./winetricks vb6run mdac28 WINEARCH="win32" WINEPREFIX="$HOME/wine-ado" wine msiexec /i mysql-connector-odbc-5.3.6-win32.msi WINEARCH="win32" WINEPREFIX="$HOME/wine-mca" wine adotest_early_53.exe
It will show a messagebox with the ODBC connection string and the error description. I tried downloading the full binary I used in wine a year ago and it too fails. This attached program is just the bare-bones needed to show the problem, to remove all unknowns.
I tried wine-2.9, wine-3.0 and wine-3.18 staging, all failed. Tried with POOLING=true, POOLING=false, and without the POOLING key at all. I tried all the internet advice I could find to no avail.
Strangely enough, when I set the ODBC connection driver to something bogus, like "carrots", it fails with the exact same reason. As if it doesn't see the MySQL ODBC connector at all.
For more info and the source code, see: http://www.vbforums.com/showthread.php?868713-Open-ADODB-connection-in-Linux...
https://bugs.winehq.org/show_bug.cgi?id=46235
Rubber baby buggy bumpers bugs@seeitmyway.org changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |bugs@seeitmyway.org
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #1 from Rubber baby buggy bumpers bugs@seeitmyway.org --- I made a typo in the third line in the "run" section, should be "wine-ado" of course.
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #2 from Nikolay Sivov bunglehead@gmail.com --- Created attachment 62936 --> https://bugs.winehq.org/attachment.cgi?id=62936 screenshot
It seems to work fine for me. Error message comes from MySql driver, on Windows where I don't have this driver installed I get "Data source name not found..." message.
I'm using latest wine from git.
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #3 from Theodore Bumpers wine@londonlight.org --- Nikolay Sivov could you tell me more: - Which wine commit are you on? Is it vanilla wine or with patches? - Which distro? - Did you use a 32-bit wine prefix? - Did you use my code verbatim? If not, could you paste what you used? - You ran it as a normal user, not as root, right?
Any other info you could provide would be much appreciated.
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #4 from Nikolay Sivov bunglehead@gmail.com --- Current wine at 0cc6233e2077c1ef679ecb8bd815d31484868294, no patches. I used example you attached, 32-bit prefix.
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #5 from Theodore Bumpers wine@londonlight.org --- I installed what Gentoo/Sabayon call "wine-any", wine-3.17. https://wiki.gentoo.org/wiki/Wine#Wine_variants
Reproduced the steps, and got the same fail message: Method '~' of object '~' failed
Full log attached.
Can you see anything in it which differs on your end?
Next I will try compiling your commit of wine.
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #6 from Theodore Bumpers wine@londonlight.org --- Created attachment 62939 --> https://bugs.winehq.org/attachment.cgi?id=62939 wine46235_1.txt
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #7 from Nikolay Sivov bunglehead@gmail.com --- Try to build latest first, and retest with new prefix using latest winetricks too.
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #8 from Theodore Bumpers wine@londonlight.org --- Using a self-compiled latest wine git the problem didn't appear!
https://bugs.winehq.org/show_bug.cgi?id=46235
--- Comment #9 from Theodore Bumpers wine@londonlight.org --- I think this issue can be closed, as using the latest vanilla wine from git results in the ADODB connection opening correctly.
https://bugs.winehq.org/show_bug.cgi?id=46235
Nikolay Sivov bunglehead@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |FIXED
--- Comment #10 from Nikolay Sivov bunglehead@gmail.com --- Okay, thanks for testing.
https://bugs.winehq.org/show_bug.cgi?id=46235
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #11 from Alexandre Julliard julliard@winehq.org --- Closing bugs fixed in 4.0-rc1.
-
wine-bugs＠winehq.org