Connection

concerns

The Connection attribute sets or determines the ADO Connection object that is the basis of the data query.

 

Syntax

Connection

Return value

ADODB.Connection

Parameter

None

 

Example:

 

Option 1 (Setting the Connection over a database connection of the properties of the Knowledge Base)

 

Dim T As Table

 

T.Connection := DBCRM

 

Option 2 (Setting the Connection over a Data Source)

 

Dim T As Table, C As Connection

C.OpenConnection("PROVIDER=SQLOleDB; SERVER=[MyServer]; DATABASE=[MyDatabase]; UID=[MyUser]; PWD=[MyPassword]")

T.Connection := C