2 The ODBC layer
AllApplicationManualNameSummaryHelp

  • Documentation
    • Reference manual
    • Packages
      • SWI-Prolog ODBC Interface
        • The ODBC layer
          • Global configuration
          • Connection management
          • Running SQL queries
          • Transaction management
          • Accessing the database dictionary
          • Getting more information
          • Representing SQL data in Prolog
          • Errors and warnings
          • ODBC implementations
            • Using unixODBC
            • Using Microsoft ODBC
          • Remaining issues

2.9 ODBC implementations

There is a wealth on ODBC implementations that are completely or almost compatible to this interface. In addition, a number of databases are delivered with an ODBC compatible interface. This implies you get the portability benefits of ODBC without paying the configuration and performance price. Currently this interface is, according to the PHP documentation on this subject, provided by Adabas D, IBM DB2, Solid, and Sybase SQL Anywhere.

2.9.1 Using unixODBC

The SWI-Prolog ODBC interface was developed using unixODBC and MySQL on SuSE Linux.

2.9.2 Using Microsoft ODBC

On MS-Windows, the ODBC interface is a standard package, linked against odbc32.lib.