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