Init_Prompt

Description

Specifies whether you want to be prompted during initialization.

When to specify Init_Prompt

You must specify the Init_Prompt parameter before connecting to the database.

Applies to

OLE DB

Syntax

Prompt='value'

Parameter

Description

value

Specifies whether you want to be prompted during initialization. Values are:

  • Not set

    Do not prompt.

  • Always

    Always prompt for initialization information.

  • If needed

    Prompt only if more information is needed.

  • If needed (required)

    Prompt only if more information is needed. Do not allow the user to enter optional information.

  • Never

    Do not prompt.


Default value

Init_Prompt='Not set'

Examples

To specify that you want always to be prompted during initialization:

  • Database profile

    Select Always from the Prompt drop-down list on the System page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="INIT_PROMPT='DBPROMPT_PROMPT'"

See also

DataLink