https://bz.apache.org/ooo/show_bug.cgi?id=128632

          Issue ID: 128632
        Issue Type: DEFECT
           Summary: Add support for iODBC on *nix
           Product: Base
           Version: 4.2.0-dev
          Hardware: All
                OS: Unix, all
            Status: CONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: code
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

We currently build our ODBC driver (SDBC to ODBC bridge) by using our own
copies of ODBC header files at compile time, but don't link to the ODBC driver
manager at compile time, rather using run-time dynamic linking to actually load
the ODBC driver manager and make calls to it.

This loading happens in LoadLibrary_ODBC3() of
main/connectivity/source/drivers/odbc/OFunctions.cxx. On Windows it loads the
one and only ODBC32.DLL. On Mac, iODBC's libiodbc.dylib. On *nix, unixODBC's
libodbc.so.1 or libodbc.so. On OS/2, "ODBC" or "WOD402".

But iODBC also works on *nix, and is in fact the only ODBC driver manager
implementation currently in FreeBSD's ports. If present, we should also try to
use it. Its libraries are called libiodbc.so.2 and libiodbc.so.
dbaccess/source/ui/dlg/odbcconfig.cxx also needs to be changed though.

Since unixODBC and iODBC use different configuration files, it would be
surprising to users who install both and upgrade OpenOffice if we started
showing iODBC data sources instead of the unixODBC data sources we showed
before. Therefore unixODBC should be tried first, and iODBC only second.

-- 
You are receiving this mail because:
You are the assignee for the issue.

Reply via email to