[Bug 54499] New: Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

Bug ID: 54499
           Summary: Native ODBC drivers should be able be used.
           Product: Wine
           Version: 8.1
          Hardware: x86-64
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: odbc
          Assignee: [e-mail]
          Reporter: [e-mail]
      Distribution: ---

Wine is unable to user native ODBC drivers which have been installed.
PostgreSQL and MySQL are two of the comment ones.

Currently the only way is to install the unixODBC driver, you require which
isn't always free.

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

Austin English  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

Alistair Leslie-Hughes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |STAGED
    Staged patchset|                            |https://github.com/wine-sta
                   |                            |ging/wine-staging/tree/mast
                   |                            |er/patches/odbc-remove-unix
                   |                            |odbc

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

Alistair Leslie-Hughes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
    Staged patchset|https://github.com/wine-sta |https://gitlab.winehq.org/w
                   |ging/wine-staging/tree/mast |ine/wine-staging/-/tree/mas
                   |er/patches/odbc-remove-unix |ter/patches/odbc-remove-uni
                   |odbc                        |xodbc

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

--- Comment #1 from Hans Leidekker  ---
(In reply to Alistair Leslie-Hughes from comment #0)
> Wine is unable to user native ODBC drivers which have been installed.
> PostgreSQL and MySQL are two of the comment ones.

I guess you mean the Windows versions of the ODBC drivers. IIRC you can use
them if you install native MDAC and add a couple of overrides.

Wouldn't we loose integration with host configuration of the drivers? Do all
relevant databases currently supported through unixODBC have a Windows driver?
> Currently the only way is to install the unixODBC driver, you require which
> isn't always free.

Can you elaborate on this? When isn't it free?

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

--- Comment #2 from Alistair Leslie-Hughes  ---
(In reply to Hans Leidekker from comment #1)
> (In reply to Alistair Leslie-Hughes from comment #0)
> > Wine is unable to user native ODBC drivers which have been installed.
> > PostgreSQL and MySQL are two of the comment ones.
>
> I guess you mean the Windows versions of the ODBC drivers. IIRC you can use
> them if you install native MDAC and add a couple of overrides.

MDAC only supports 32bit and is a standard component I install for ODBC support
but since moving to 64bits it's not longer a viable option.
> Wouldn't we loose integration with host configuration of the drivers? Do all
> relevant databases currently supported through unixODBC have a Windows
> driver?

Yes we would loose integration to the host configuration.

To my knowledge most database vendors who support windows would have a ODBC
driver.  From experience all the database I've used, both free and commercial
have a windows driver of some sort.
> > Currently the only way is to install the unixODBC driver, you require which
> > isn't always free.
>
> Can you elaborate on this? When isn't it free?

The "Microsoft SQL Server" driver isn't free to use with unixODBC for example.

Most Database drivers for windows are free to use, its the database server that
usually cost.

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

--- Comment #3 from Hans Leidekker  ---
(In reply to Alistair Leslie-Hughes from comment #2)
> (In reply to Hans Leidekker from comment #1)
> > (In reply to Alistair Leslie-Hughes from comment #0)
> > > Wine is unable to user native ODBC drivers which have been installed.
> > > PostgreSQL and MySQL are two of the comment ones.
> >
> > I guess you mean the Windows versions of the ODBC drivers. IIRC you can use
> > them if you install native MDAC and add a couple of overrides.
>
> MDAC only supports 32bit and is a standard component I install for ODBC
> support but since moving to 64bits it's not longer a viable option.

This is a good reason to change Wine to use Windows drivers.
> > Wouldn't we loose integration with host configuration of the drivers? Do all
> > relevant databases currently supported through unixODBC have a Windows
> > driver?
>
> Yes we would loose integration to the host configuration.

That's unfortunate but I guess most users would set up unixODBC drivers
specifically
for use with Wine. They would just need to switch to Windows drivers. Users who
shared a configuration with Unix apps will somehow need to synchronize though.
> To my knowledge most database vendors who support windows would have a ODBC
> driver.  From experience all the database I've used, both free and
> commercial have a windows driver of some sort.

I guess it's reasonable to assume that if there's a unixODBC driver for a given
database a corresponding Windows driver exists as well.
> > > Currently the only way is to install the unixODBC driver, you require which
> > > isn't always free.
> >
> > Can you elaborate on this? When isn't it free?
>
> The "Microsoft SQL Server" driver isn't free to use with unixODBC for
> example.

It's still not clear to me. You mean it costs money to use unixODBC driver for
Microsoft SQL Server? Is that different from the Windows driver?

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

--- Comment #4 from Alistair Leslie-Hughes  ---
(In reply to Hans Leidekker from comment #3)
> (In reply to Alistair Leslie-Hughes from comment #2)
> > (In reply to Hans Leidekker from comment #1)
> > > (In reply to Alistair Leslie-Hughes from comment #0)
> > > > Wine is unable to user native ODBC drivers which have been installed.
> > > > PostgreSQL and MySQL are two of the comment ones.
>
> It's still not clear to me. You mean it costs money to use unixODBC driver
> for Microsoft SQL Server? Is that different from the Windows driver?

Yes, that is exactly the case.  You can freely download the ODBC drivers for
Microsoft SQL Server drivers off MSDN.  In this case the server is where they
make their money.

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

--- Comment #5 from Austin English  ---
The MS ODBC drivers are also non-freely licensed. I had to try installing it to
find the actual license. For reference, it's at:

https://odbceula.blob.core.windows.net/eula17/LICENSE17.TXT (at least for
version 17..).

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

--- Comment #6 from Hans Leidekker  ---
(In reply to Alistair Leslie-Hughes from comment #4)
> (In reply to Hans Leidekker from comment #3)
> > (In reply to Alistair Leslie-Hughes from comment #2)
> > > (In reply to Hans Leidekker from comment #1)
> > > > (In reply to Alistair Leslie-Hughes from comment #0)
> > > > > Wine is unable to user native ODBC drivers which have been installed.
> > > > > PostgreSQL and MySQL are two of the comment ones.
> >
> > It's still not clear to me. You mean it costs money to use unixODBC driver
> > for Microsoft SQL Server? Is that different from the Windows driver?
>
> Yes, that is exactly the case.  You can freely download the ODBC drivers for
> Microsoft SQL Server drivers off MSDN.  In this case the server is where
> they make their money.

Freely downloadable is a different issue. The Linux driver is freely
downloadable as well:

https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-...

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

--- Comment #7 from Hans Leidekker  ---
And I guess that would get you 64-bit support as well.

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

--- Comment #8 from Alistair Leslie-Hughes  ---
(In reply to Hans Leidekker from comment #7)
> And I guess that would get you 64-bit support as well.

Maybe it would.

It just comes down to how normal wine users would use it.  The group of users I
support, using a native(windows) driver seems to be there natural choose.

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

Hans Leidekker  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|STAGED                      |RESOLVED
      Fixed by SHA1|                            |a312fad7b53590360fb356a4d2b
                   |                            |ab115aafe2dd0

[Bug 54499] Native ODBC drivers should be able be used.

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=54499

Alexandre Julliard  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #9 from Alexandre Julliard  ---
Closing bugs fixed in 9.13.