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
実行時設定
php.ini の設定により動作が変化します。
下表では、SQLSRV 拡張モジュールで使用可能な構成オプションを一覧表示します。 これらのオプションについて詳しくは、 » Handling SQLSRV Warnings and Errors をご覧下さい。
| 名前 | デフォルト | 変更可能 | 変更履歴 |
|---|---|---|---|
| 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
baklanoid at gmail dot com ¶
4 years ago
robert dot urbanski2 at gmail dot com ¶
8 years ago
Do not omitt these parameters
client_buffer_max_kb_size = '50240'
sqlsrv.ClientBufferMaxKBSize = 50240
