HomePowerBuilderAppeon Documentation Center

Mode

Description

Specifies access permission to the OLE DB data provider.

When to specify Mode

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

Applies to

OLE DB

Syntax

Mode='value'

Parameter

Description

value

Specifies access permission to the OLE DB data provider. Values are:

  • Deny read share

    Prevents other users from opening in read mode.

  • Deny write share

    Prevents other users from opening in write mode.

  • Exclusive share

    Prevents other users from opening in read/write mode.

  • No share deny

    Neither read nor write access can be denied to other users.

  • Read/Write

    Allows read/write access.

  • Read-only

    Allows read access.

  • Write-only

    Allows write access.

Default value

None

Examples

To allow other users read/write access to the OLE DB data provider:

  • Database profile

    On the Transaction page in the Database Profile Setup dialog box, select Read/Write from the Mode list box.

  • Application

    Type the following in code:

    SQLCA.DBParm="MODE='DB_MODE_READWRITE'"

See also

DataLink

Prev  Up  Next
MixedCase  Home  MsgTerse