Události ADO WillConnect , ConnectComplete a Disconnect


❮ Vyplňte Reference objektu připojení

Událost je podprogram, který lze volat automaticky po provedení určité operace.

  • Událost WillConnect lze vyvolat před zahájením připojení.
  • Událost ConnectComplete lze vyvolat po zahájení připojení.
  • Událost Disconnect lze vyvolat po ukončení připojení.

Syntax

WillConnect ConnectionString,userid,psword,options,status,objcon

ConnectComplete objerror,status,objconn

Disconnect status,objconn

Parameter Description
ConnectionString A string that contains the information required for the connection
userid A string that contains the user name for the connection
psword A string that contains the password for the connection
options A long value that specifies how the provider should evaluate the ConnectionString. Can only be set to adAsyncOpen
objerror An Error object that contains the errors that occurred

Note: The EventStatusEnum value must be set to adStatusErrorsOccurred to create the Error object

status An EventStatusEnum value. Default is adStatusOK

However, when the ConnectComplete event is called, this parameter is set to adStatusCancel IF a WillConnect event calls for cancelling of the pending connection

objconn The Connection object that fired the event 

Hodnoty EventStatusEnum

Constant Value Description
adStatusOK 1 The operation that fired the event was successful
adStatusErrorsOccurred 2 The operation that fired the event failed
adStatusCantDeny 3 Cannot cancel the pending operation
adStatusCancel 4 Cancels the operation that fired the event
adStatusUnwantedEvent 5 Prevents subsequent notifications before the event method has finished executing

❮ Vyplňte Reference objektu připojení