CakeFest 2024: The Official CakePHP Conference

実行時設定

php.ini の設定により動作が変化します。

下表では、SQLSRV 拡張モジュールで使用可能な構成オプションを一覧表示します。 これらのオプションについて詳しくは、 » Handling SQLSRV Warnings and Errors をご覧下さい。

SQLSRV 設定オプション
名前 デフォルト 変更可能 変更履歴
sqlsrv.WarningsReturnAsErrors 1 (true) INI_ALL SQLSRV 1.0 以降で使用可能
sqlsrv.LogSubsystems 0 INI_ALL SQLSRV 1.0 以降で使用可能
sqlsrv.LogSeverity 1 INI_ALL SQLSRV 1.0 以降で使用可能

add a note

User Contributed Notes 2 notes

up
3
baklanoid at gmail dot com
3 years ago
Hey-ho wayfarer! Here is some assembly i did, you may find it useful in your php.ini file :)

[sqlsrv]
; By default, the SQLSRV driver treats warnings as errors;
; a call to a sqlsrv function that generates
; an error or a warning returns false.
sqlsrv.WarningsReturnAsErrors = 1

; By default, errors and warnings that are generated by
; the Microsoft Drivers for PHP for SQL Server are not logged
; LogSubsystems can be one of the following values:
; -1 - Turns on logging of all subsystems.
; 0 - Turns logging off (This is the default).
; 1 - Turns on logging of initialization activity.
; 2 - Turns on logging of connection activity.
; 4 - Turns on logging of statement activity.
; 8 - Turns on logging of error functions activity (such as handle_error and handle_warning).
; These values may be combined with logical OR,
; for example, 6 - connection + statement
sqlsrv.LogSubsystems = -1

; LogSeverity can be one of the following values
; (LOGGING ACTIVITY USING THE PDO_SQLSRV DRIVER):
; -1 - Specifies that errors, warnings, and notices are logged.
; 0 - Logging is disabled (This is the default).
; 1 - Specifies that errors are logged.
; 2 - Specifies that warnings are logged.
; 4 - Specifies that notices are logged.
; Logging information is added to the error_log (php_errors.log) file.
; These values may be combined with logical OR,
; for example, 3 - errors + warnings
sqlsrv.LogSeverity = 1
up
-32
robert dot urbanski2 at gmail dot com
7 years ago
Do not omitt these parameters

client_buffer_max_kb_size = '50240'
sqlsrv.ClientBufferMaxKBSize = 50240
To Top