[Bug 46235] New: Opening ADODB.Connection results in: Method '~' of object '~' failed
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(a)winehq.org Reporter: bugs(a)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... -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 Rubber baby buggy bumpers <bugs(a)seeitmyway.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bugs(a)seeitmyway.org -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #1 from Rubber baby buggy bumpers <bugs(a)seeitmyway.org> --- I made a typo in the third line in the "run" section, should be "wine-ado" of course. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #2 from Nikolay Sivov <bunglehead(a)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. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #3 from Theodore Bumpers <wine(a)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. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #4 from Nikolay Sivov <bunglehead(a)gmail.com> --- Current wine at 0cc6233e2077c1ef679ecb8bd815d31484868294, no patches. I used example you attached, 32-bit prefix. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #5 from Theodore Bumpers <wine(a)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. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #6 from Theodore Bumpers <wine(a)londonlight.org> --- Created attachment 62939 --> https://bugs.winehq.org/attachment.cgi?id=62939 wine46235_1.txt -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #7 from Nikolay Sivov <bunglehead(a)gmail.com> --- Try to build latest first, and retest with new prefix using latest winetricks too. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #8 from Theodore Bumpers <wine(a)londonlight.org> --- Using a self-compiled latest wine git the problem didn't appear! -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 --- Comment #9 from Theodore Bumpers <wine(a)londonlight.org> --- I think this issue can be closed, as using the latest vanilla wine from git results in the ADODB connection opening correctly. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 Nikolay Sivov <bunglehead(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |FIXED --- Comment #10 from Nikolay Sivov <bunglehead(a)gmail.com> --- Okay, thanks for testing. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=46235 Alexandre Julliard <julliard(a)winehq.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED --- Comment #11 from Alexandre Julliard <julliard(a)winehq.org> --- Closing bugs fixed in 4.0-rc1. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
participants (1)
-
wine-bugs＠winehq.org