Runtime Configuration

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

Unified ODBC Configuration Options
NameDefaultChangeableChangelog
odbc.default_db *NULLINI_ALL 
odbc.default_user *NULLINI_ALL 
odbc.default_pw *NULLINI_ALL 
odbc.allow_persistent"1"INI_SYSTEM 
odbc.check_persistent"1"INI_SYSTEM 
odbc.max_persistent"-1"INI_SYSTEM 
odbc.max_links"-1"INI_SYSTEM 
odbc.defaultlrl"4096"INI_ALL 
odbc.defaultbinmode"1"INI_ALL 
odbc.default_cursortype"3"INI_ALL 

Note: Entries marked with * are not implemented yet.

For further details and definitions of the INI_* modes, see the Where a configuration setting may be set.

Here's a short explanation of the configuration directives.

odbc.default_dbstring

ODBC data source to use if none is specified in odbc_connect() or odbc_pconnect().

odbc.default_userstring

User name to use if none is specified in odbc_connect() or odbc_pconnect().

odbc.default_pwstring

Password to use if none is specified in odbc_connect() or odbc_pconnect().

odbc.allow_persistentbool

Whether to allow persistent ODBC connections.

odbc.check_persistentbool

Check that a connection is still valid before reuse.

odbc.max_persistentint

The maximum number of persistent ODBC connections per process.

The maximum number of ODBC connections per process, including persistent connections.

odbc.defaultlrlint

Handling of LONG fields. Specifies the number of bytes returned to variables. See odbc_longreadlen() for details.

When an int is used, the value is measured in bytes. Shorthand notation, as described in this FAQ, may also be used.
odbc.defaultbinmodeint

Handling of binary data. See odbc_binmode() for details.

odbc.default_cursortypeint

Controls the ODBC cursor model. Possible values are SQL_CURSOR_FORWARD_ONLY, SQL_CURSOR_KEYSET_DRIVEN, SQL_CURSOR_DYNAMIC and SQL_CURSOR_STATIC (default).

To Top