'Declaration
 
Public Overloads Overrides NotOverridable Function OpenAsync( _
   ByVal cancellationToken As CancellationToken _
) As Task

'Usage
 
Dim instance As TdConnection
Dim cancellationToken As CancellationToken
Dim value As Task
 
value = instance.OpenAsync(cancellationToken)

public override Task OpenAsync( 
   CancellationToken cancellationToken
)

public:
Task^ OpenAsync( 
   CancellationToken cancellationToken
) override 

Parameters

cancellationToken

A Threading.CancellationToken used to indicate that the asynchronous operation should be canceled.

Return Value

If this function generates a runtime exception, that exception will be wrapped in an AggregateException within the returned Task.

After calling OpenAsync, TdConnection.State will return Connecting until the returned Task is completed. Then, if the connection was successful, State will return Open. If the connection fails, State will return Closed.

A call to TdConnection.Close while an OpenAsync task is executing will attempt to cancel the task before closing the connection.

If you wish to be able to cancel the OpenAsync task you must create a Threading.CancellationTokenSource and pass its Threading.CancellationTokenSource.Token to this method. To cancel the task, call the Threading.CancellationTokenSource.Cancel method.

If the TdConnectionStringBuilder.ConnectionTimeout is reached before the task completes the task will be cancelled.

If a connection to the Advanced SQL Engine has already been established when cancellation is requested the cancel request will be ignored.

If connection pooling is turned off, TdConnection attempts to establish a new Teradata session. Otherwise, the ConnectionPool either returns an existing Teradata Session or creates a new Teradata session if the number of pooled sessions is less than Max Pooled Size.

If the connection string has a Database attribute, the TdConnection.ChangeDatabase method is called immediately after a session is opened to Teradata. This will result in additional roundtrips to the Advanced SQL Engine. We strongly recommend that you modify the User (See Teradata manual for information on Create User or Alter User) and add a default database. This will enhance the overall performance of opening a connection to the Advanced SQL Engine. Please note that ChangeDatabase method is called independently of whether the connection pooling is turned on or off and errors generated as a result of an invalid supplied ConnectionString Database attribute are ignored.

If the password has expired and pooling is turned off, then an TdConnection.InfoMessage event is triggered. The application should respond to the event by:

1) Change the password
2) Close the TdConnection
3) Open the TdConnection

Alternatively, the application can set the ‘New Password’ attribute in the connection string.

Reference

TdConnection Class
TdConnection Members
Overload List