Each connection object can support multiple named connections. These connections can represent connections to multiple databases and database types.
To add a new connection
- Select an existing BdpConnection component in the designer, or drop a BdpConnection component onto the designer to create a new object.
- Click the component designer tab at the bottom of the Object Inspector to display the Connection Editor dialog.
- Click Add to display the Add New Connection dialog.
- Select a provider from the Provider Name drop-down list box.
- Enter a new name for the connection in the Connection Name text box.
- Click OK.
- Enter the appropriate values for your particular data source.
- Click OK.
To remove a connection
- Select the connection type until it is highlighted.
- Click Remove. A Confirm Delete dialog box appears.
- Click Yes.
To rename a connection
- Right-click on the connection and choose Rename.
- Type the new name of the connection.
- Click OK.