Connect( UserID, Password )
true if the connection is made. Otherwise, false.
UserID – a valid ID name for an SQL user. UserID can be a string or a variable that evaluates to a string. This parameter is optional. The system can use the default value set up in the Database tab of the Publication Properties dialog.
Password – a valid password for the UserID. Password can be a string or a variable that evaluates to a string. This parameter is optional; the system can use the default value set up in the Database tab of the Publication Properties dialog.
This function will connect to an SQL server. You cannot connect to an SQL server unless you have a valid user ID and password.