2.2 Connection management
AllApplicationManualNameSummaryHelp

  • Documentation
    • Reference manual
    • Packages
      • SWI-Prolog ODBC Interface
        • The ODBC layer
          • Connection management
            • odbc_connect/3
            • odbc_driver_connect/3
            • odbc_disconnect/1
            • odbc_current_connection/2
            • odbc_set_connection/2
            • odbc_get_connection/2
            • odbc_data_source/2
Availability::- use_module(library(odbc)).(can be autoloaded)
odbc_get_connection(+Connection, ?Property)
Query for properties of the connection. Property is a term of the format Name(Value). If Property is unbound all defined properties are enumerated on backtracking. Currently the following properties are defined.
database_name(Atom)
Name of the database associated to the connection.
dbms_name(Name)
Name of the database engine. This constant can be used to identify the engine.
dbms_version(Atom)
Version identifier from the database engine.
driver_name(Name)
ODBC Dynamic Link Library providing the interface between ODBC and the database.
driver_odbc_version(Atom)
ODBC version supported by the driver.
driver_version(Atom)
The drivers version identifier.
active_statements(Integer)
Maximum number of statements that can be active at the same time on this connection. Returns 0 (zero) if this is unlimited.2Microsoft SQL server can have multiple active statements after setting the option cursor_type to dynamic. See odbc_set_connection/2.