Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Changes the settings for error handling and logging options.
Syntax
sqlsrv_configure( string $setting, mixed $value )
Parameters
$setting: The name of the setting to be configured. See the table below for a list of settings.
$value: The value to be applied to the setting specified in the $setting parameter. The possible values for this parameter depend on which setting is specified. The following table lists the possible combinations:
| Setting | Possible values for $value parameter (integer equivalent in parentheses) | Default value |
|---|---|---|
| ClientBufferMaxKBSize1 | A non negative number up to the PHP memory limit. Zero and negative numbers are not allowed. |
10240 KB |
| LogSeverity2 | SQLSRV_LOG_SEVERITY_ALL (-1) SQLSRV_LOG_SEVERITY_ERROR (1) SQLSRV_LOG_SEVERITY_NOTICE (4) SQLSRV_LOG_SEVERITY_WARNING (2) |
SQLSRV_LOG_SEVERITY_ERROR (1) |
| LogSubsystems2 | 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) |
SQLSRV_LOG_SYSTEM_OFF (0) |
| WarningsReturnAsErrors3 | true (1) or false (0) | true (1) |
Return Value
If sqlsrv_configure is called with an unsupported setting or value, the function returns false. Otherwise, the function returns true.
Remarks
(1) For more information about client-side queries, see Cursor Types (SQLSRV Driver).
(2) For more information about logging activity, see Logging Activity.
(3) For more information about configuring error and warning handling, see How to: Configure Error and Warning Handling Using the SQLSRV Driver.
See Also
Programming Guide for the Microsoft Drivers for PHP for SQL Server