The final step in connecting to an OLE DB data provider is to test the OLE DB data provider connection. Before you test the connection, you must select the OLE DB data provider in the OLE Properties dialog box for the Data Control and select or enter the database that you want access to. If the OLE DB data provider is secured, you must also enter or select the appropriate security information.
If the connection succeeds, a dialog box with the message Test Connection Succeeded appears. If the connection does not succeed, a dialog box with the message Test Connection Failed appears along with an error returned. Click OK. For more information about troubleshooting failed connections, see Assessing Failed Test Connections.
See Also
