Creating a New Data Connection

You need a data connection to a data source before you can work with data from that database. As we saw in the EasyAccess example in the In Depth section of this chapter, you can create a new data connection in the Server Explorer by right-clicking the Data Connections icon in the Server Explorer and selecting the Add Connection item (or use the Tools|Connect to Database menu item). This opens the Data Link Properties dialog you see in Figure 20.4; you can use this dialog to create a new data connection.

To delete a data connection, right-click it in the Server Explorer and click Delete.