







![]() ![]() |
Microsoft Drivers for PHP for SQL Server version 2.0 and 3.0 |
sqlsrv_configure |
See Also Send Feedback |
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 table below for 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 (0) means no limit to the buffer size. |
10240 |
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.