sqlsrv_configure

Download PHP driver

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

SQLSRV Driver API Reference

Programming Guide for the Microsoft Drivers for PHP for SQL Server