Home > PHP > Function > ODBC > odbc_setoption()

odbc_setoption()

odbc_setoption - Adjust ODBC settings

Syntax

bool odbc_setoption (resource $id, int $function, int $option, int $param)

Arguments

  • id - Is a connection id or result id on which to change the settings. For SQLSetConnectOption(), this is a connection id. For SQLSetStmtOption(), this is a result id.
  • function - Is the ODBC function to use. The value should be 1 for SQLSetConnectOption() and 2 for SQLSetStmtOption().
  • option - The option to set.
  • param - The value for the given option.

Description

This function allows fiddling with the ODBC options for a particular connection or query result. It was written to help find work around to problems in quirky ODBC drivers. You should probably only use this function if you are an ODBC programmer and understand the effects the various options will have. You will certainly need a good ODBC reference to explain all the different options and values that can be used. Different driver versions support different options.

Version

PHP 4, 5

Return value

Returns TRUE on success or FALSE on failure.