If you have MDAC installed you can use the Microsoft Data Link to set up your connection string. This will prompt you for information such as the OLE DB Provider, the database in which the data is stored, and the server on which the data resides.
Figure 0.6 Microsoft Data Link
