Returns or sets a value that specifies if the ODBC driver manager should prompt for missing connect string arguments.
Syntax
object.Prompt [= value]
The Prompt property syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| value | A constant or Integer as described in Settings. |
Settings
The settings for the Prompt property are:
| Constant | Value | Description |
| rdDriverPrompt | 0 | The driver manager displays the ODBC Data Sources dialog box. The connection string used to establish the connection is constructed from the data source name (DSN) selected and completed by the user via the dialog boxes. Or, if no DSN is chosen and the DataSourceName property is empty, the default DSN is used. |
| rdDriverNoPrompt | 1 | The driver manager uses the connection string provided in connect. If sufficient information is not provided, the OpenConnection method returns a trappable error. |
| rdDriverComplete | 2 | If the connection string provided includes the DSN keyword, the driver manager uses the string as provided in connect, otherwise it behaves as it does when rdDriverPrompt is specified. |
| rdDriverCompleteRequired | 3 | (Default) Behaves like rdDriverComplete except the driver disables the controls for any information not required to complete the connection. |
Remarks
When RDO opens a connection based on the parameters of the RemoteData control, the Connect property is expected to contain sufficient information to establish the connection. If information like the data source name, user name, or password are not provided, the ODBC driver manager exposes one or more dialog boxes to gather this information from the user. If you do not want these dialog boxes to appear, set the Prompt property accordingly to disable this feature.
The constants shown above are also used to set the ODBC prompt behavior for the EstablishConnection method.