Read-write. Prevents display of a User ID and Password dialog box during program execution.

Defined in

ODBCConnection

Data type

Boolean

Syntax

To get: status = odbcConnection. SilentMode

To set: odbcConnection.SilentMode = status

Legal values

• True indicates that SilentMode is successfully set.
• False indicates that SilentMode is not set.

If SilentMode is set, the connection is attempted, but may fail.

If the User ID and Password are supplied as arguments, the connection simply either succeeds or fails. (If supplied to a data source that doesn't need them, the connection succeeds.) SilentMode applies to cases where the User ID and Password are not supplied as arguments, but are required.

Some ODBC drivers use several layers of software to reach the data, and an intermediate layer may prompt directly for the user ID and password, ignoring the request not to do so.

Example
See Also

ConnectTo method
IsSupported method

Glossary