The following code shows how to set the Connect property at design time:
<OBJECT CLASSID="clsid: 9381D8F2-0288-11d0-9501-00AA00B911A5" ID="ADC1"> . . . <PARAM NAME="SQL" VALUE="Select * from Sales"> <PARAM NAME="Connect" VALUE="DSN=SalesDB;UID=SMgr;PWD=password;"> <PARAM NAME="Server" VALUE="http://SalesWeb"> . . . </OBJECT>
The following example shows how to set the Connect property at run time in VBScript code:
ADC1.Connect = "DSN=SalesDB;UID=SMgr;PWD=password;"