1. In the Data Link Properties dialog box, click the Provider tab, and then click Microsoft OLE DB Provider for Oracle.
2. Click the Connection tab, and under Enter a server name, type the name of your Oracle database server.
3. Under Enter information to log on to the database, do one of the following:
   If you want users to enter a login name and password to access the data in the PivotTable® list when they open your Web page, type the login name in the User name box and type the password in the Password box.
   If you don't want users to have to enter a password, type the login name in the User name box, type the password in the Password box, and select the Allow saving password check box.
   If your database does not require a password for access and you don't want users to have to log in, select the Blank password check box, and then select the Allow saving password check box. Leave the User name box blank.
4. If you want to verify that the connection you've set up works, click Test Connection.
5. Click OK in the Data Link Properties dialog box, and if prompted about saving the password, click Yes.
6. In the Property Toolbox, under Use data from, click Data member, and then select the table that contains the data you want to display in the PivotTable list.

You may notice that the Data Link Properties dialog box contains some advanced options for developers. If you're interested in learning about these options, click the Help button in the dialog box, and also see the programming Help for PivotTable lists. For information about displaying this Help, click the Help button in a PivotTable list that you're designing, and see "How to get assistance writing programs and scripts for PivotTable lists".

When you complete the instructions for connecting to your database, the drop areas should appear in the PivotTable list, and the data should be available for display. Click the Field List button on the toolbar in the PivotTable list to display the data fields that you can now drag onto the PivotTable list.

Where Can I Get More Information?

• For comprehensive information about designing PivotTable lists, click the Help button on the toolbar in a PivotTable list that you're designing, and see "About designing and publishing PivotTable lists for the Web."
• For information about using Microsoft Access 2000 to connect to databases, type data sources in the Office Assistant or on the Answer Wizard tab in the Access Help window, and then click Search.
• For information about using Excel to set up data sources, type data sources in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.