The CONNECT statement is required when connecting to OLE DB providers by way of the SQL Pass-Through Facility. Note: Not all of these engine-connection options are supported by all OLE DB providers.

Using the CONNECT statement is optional for some DBMSs. However, if it is not specified, the default values for all of the database connection arguments are used. Any return code or message that is ...