Edit Report a Bug

    sqlsrv_configure

    (No version information available, might only be in Git)

    sqlsrv_configure — Changes the driver error handling and logging configurations

    説明

    sqlsrv_configure(string $setting, mixed $value): bool

    Changes the driver error handling and logging configurations.

    パラメータ

    setting

    The name of the setting to set. The possible values are "WarningsReturnAsErrors", "LogSubsystems", and "LogSeverity".

    value

    The value of the specified setting. The following table shows possible values:

    Error and Logging Setting Options
    Setting Options
    WarningsReturnAsErrors 1 (true) or 0 (false)
    LogSubsystems SQLSRV_LOG_SYSTEM_ALL (-1) SQLSRV_LOG_SYSTEM_CONN (2) SQLSRV_LOG_SYSTEM_INIT (1) SQLSRV_LOG_SYSTEM_OFF (0) SQLSRV_LOG_SYSTEM_STMT (4) SQLSRV_LOG_SYSTEM_UTIL (8)
    LogSeverity SQLSRV_LOG_SEVERITY_ALL (-1) SQLSRV_LOG_SEVERITY_ERROR (1) SQLSRV_LOG_SEVERITY_NOTICE (4) SQLSRV_LOG_SEVERITY_WARNING (2)

    戻り値

    成功した場合に true を、失敗した場合に false を返します。

    add a note add a note

    User Contributed Notes 1 note

    up
    -8
    smhahmadi
    11 years ago
    Performance tip:

    Beware of the performance penalty involved with unchecked use of logging options. In my case, although I was using the buffered cursor, sqlsrv_fetch_array was running too slowly. The solution was to remove my lavish use of those configuration options (using both SQLSRV_LOG_SYSTEM_ALL and SQLSRV_LOG_SEVERITY_ALL).
    add a note add a note
    To Top