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