[Bug 46235] New: Opening ADODB.Connection results in: Method '~' of object '~' failed

[wine-bugs at winehq.org]

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 at winehq.org
          Reporter: bugs at 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-win32.msi
- 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-wine-using-mysql-connector-odbc

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