Indicates whether an option is supported by the data source.

Defined in

ODBCConnection

Syntax

status = odbcConnection. IsSupported( option )

Parameters

option

Constant. Must be one of the following:

DB_SUPP_CURSORS
DBMS uses cursors.

DB_SUPP_PROCEDURES
DBMS has a stored-procedure capability.

DB_SUPP_READONLY
DBMS or its driver can put the data into read-only mode. For some drivers, an incorrect value is returned. The incorrect value is usually False, indicating that the READONLY option is not supported, when in fact it is supported.

DB_SUPP_SILENTMODE
DBMS can silently deny access if the user ID or password fails.

DB_SUPP_TRANSACTIONS
DBMS supports transaction mode, allowing you to specify when updates are committed to the data source, rather than using auto-commit to commit each update immediately.

• True indicates that the specified option is supported by the data source.
• False indicates that the option is not supported by the data source.

Use IsSupported to test whether the connected data source supports a particular option before attempting to use it, thus avoiding potential errors in your script.

Example
See Also

DeleteRow method (in ODBCResultSet)
Execute method (in ODBCResultSet)
ListProcedures method
ReadOnly property (in ODBCResultSet)
SilentMode property
UpdateRow method (in ODBCResultSet)

Glossary