ADO WillConnect、 ConnectComplete、および Disconnectイベント
❮完全な接続オブジェクトリファレンス
イベントは、特定の操作が発生した後に自動的に呼び出すことができるサブルーチンです。
- WillConnectイベントは、接続が開始する前に発生する可能性があります。
- ConnectCompleteイベントは、接続の開始後に発生する可能性があります。
- 接続が終了した後、Disconnectイベントを発生させることができます。
構文
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 |
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 |
❮完全な接続オブジェクトリファレンス