Runtime Configuration

The behaviour of these functions is affected by settings in php.ini.

The following table lists the configuration options available in the SQLSRV extension. For more information about these options, see » Handling SQLSRV Warnings and Errors.

SQLSRV Configure Options
Name Default Changeable Changelog
sqlsrv.WarningsReturnAsErrors 1 (true) INI_ALL Available since SQLSRV 1.0
sqlsrv.LogSubsystems 0 INI_ALL Available since SQLSRV 1.0
sqlsrv.LogSeverity 1 INI_ALL Available since SQLSRV 1.0
add a note

User Contributed Notes 1 note

up
4
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
To Top