Syntax

object.SetConnection  sConnName,  sConnStr

sConnName        String that specifies the name of an existing connection node.

sConnStr            String that specifies a connection string to be passed to sConnName.

Description

Call this method pass a connection string to a connection object before instantiation. This function may be used to set the connection string before opening or instantiating a connection (see OpenConnection).

Remarks

SetConnection method returns True if the connection is set successfully, otherwise returns False.

Example

This sample code shows how to change the connection string of the specified connection at run time in ELS-QB component..

‘.........................

Dim sConn1, sConn2, sConnStr1

sConn1 = “Connection1”

sConn2 = “Connection2”

sConnStr1 = ELS_QBCtrl.GetConnection(sConnStr1)

ChangeConnString sConn2, sConnStr1

‘..............................

Private Function ChangeConnString(sConn As String, sConnStr As String) As Boolean

ChangeConnString = True

Dim sCurrConnStr

sCurrConnStr = ELS_QBCtrl.GetConnection(strConn)

If sCurrConnStr <> sConnStr Then

ChangeConnString =ELS_QBCtrl SetConnection(strConn, strConnStr)

End If

  End Function