Microsoft KB Archive/321493

= FP: &quot;The PivotTable List Could Not Connect to Data Source&quot; Error Message When You View a Web Page That Contains a PivotTable Component =

Article ID: 321493

Article Last Modified on 6/29/2007

-

APPLIES TO


 * Microsoft FrontPage 2002 Standard Edition
 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q321493



SYMPTOMS
When you try to view a page of your Microsoft FrontPage Web that contains a PivotTable list component, you may receive the following error message:

The PivotTable list  could not connect to data source. For information about the data source, contact the creator of the file.

0x80004005: &quot;[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.&quot;

You can access the Web page and view the PivotTable component from your own computer where FrontPage is installed and on which you created the Web page. This problem occurs only when you try to access the page from a remote computer.



CAUSE
This problem occurs if the PivotTable component cannot connect to the Open Database Connectivity (ODBC) data source on the server.



RESOLUTION
To resolve this problem, use one of the following methods, as appropriate to your situation.

NOTE: The steps in the following methods assume that you use a Microsoft Access database as the data source.

Method 1
In this method, use the Microsoft OLE DB Provider for ODBC Drivers to configure the PivotTable component for the System Data Source Name (DSN). Then on each client computer, map a drive to the database share on the server, and then create a System DSN.

On the Server Computer
 Create a share for the database on the server. Assign appropriate permissions to users to access the share. Create and configure the System (DSN) for the database.

For additional information about how to create a System DSN, click the article numbers below to view the articles in the Microsoft Knowledge Base:

265034 FP2000: How to Change from File DSN to System DSN in FrontPage

305599 HOW TO: Create a System Data Source Name in Windows XP

 Configure the PivotTable component to connect to the System DSN that you created in step 3:  Start FrontPage, and then open the page that contains the PivotTable component. On the PivotTable toolbar, click Property Toolbox.</li> Click Data Source, click Connection, and then click Connection Editor.</li> Click the Provider tab.</li> In the OLE DB Provider(s) list, click Microsoft OLE DB Provider for ODBC Drivers, and then click Next.</li> Under Specify the source of data, click to select Use data source name, click the name of the data source that you created in step 3, and then click OK.</li> Click Data member under User data from in the PivotTable Property Toolbox dialog box, and then click the database element that you want.</li> Close the PivotTable Property Toolbox dialog box.</li></ol> </li></ol>

On the Client Computer
<ol> Install Microsoft Office XP or Microsoft Office 2000 (if it is not already installed).</li> Map a drive to the share on the server that contains the database. For example, \\ \ .</li> Create a System DSN that uses the same name as the DSN on the server, and point it to the server DSN.

For additional information about how to create a System DSN, click the article numbers below to view the articles in the Microsoft Knowledge Base:

265034 FP2000: How to Change from File DSN to System DSN in FrontPage

305599 HOW TO: Create a System Data Source Name in Windows XP

</li></ol>

Method 2
In this method, use the Microsoft Jet 4.0 OLE DB Provider and a Universal Naming Convention (UNC) path to the database when you configure the PivotTable component on the server computer. By doing so, users of client computers do not have to map a drive to the database share on the server or create a System DSN to access the Web page and view the PivotTable component.

On the Server Computer
<ol> Create a share for the database on the server.</li> Assign appropriate permissions (at least Read and Change permissions) to users to access the share.

For additional information about how to create a System DSN, click the article numbers below to view the articles in the Microsoft Knowledge Base:

265034 FP2000: How to Change from File DSN to System DSN in FrontPage

305599 HOW TO: Create a System Data Source Name in Windows XP

</li> Create and configure the System DSN for the database.</li> Configure the PivotTable component to connect to the System DSN that you created in step 3: <ol style="list-style-type: lower-alpha;"> Start FrontPage, and open the page that contains the PivotTable component.</li> On the PivotTable toolbar, click Property Toolbox.</li> Click Data Source, click Connection, and then click Connection Editor.</li> <li>Click the Provider tab.</li> <li>In the OLE DB Provider(s) list, click Microsoft Jet 4.0 OLE DB Provider, and then click Next.</li> <li>Under Select or enter a database name, type the UNC path to the database. For example, type \\ServerName\ShareName\Database.mdb, and then click OK.</li> <li>Click Data member under User data from in the PivotTable Property Toolbox dialog box, and then click the database element that you want.</li></ol> </li></ol>

On the Client Computer
Install Office XP or Office 2000 (if it is not already installed) on the client computers. You do not have to map a drive to the database share on the server or create a System DSN.

<div class="moreinformation_section">

MORE INFORMATION
For more information about PivotTables and other Microsoft Office Web components, visit the following Microsoft Web site, and then see the Microsoft Office 2000 Web Components white paper:

Microsoft Office 2000 Web Components

http://www.microsoft.com/office/previous/webtech/WebCmpnt.asp

Also, visit the following Microsoft Web site, and then see the &quot;Microsoft Office 2000 Web Components Basics&quot; article:

Microsoft Office 2000 Web Components Basics

http://msdn2.microsoft.com/en-us/library/aa155769(office.10).aspx

For more information about how to work with Office 2000 Web components, visit the following Microsoft Web site, and then see the &quot;Office Web Components&quot; section:

Microsoft Office Development with Visual Studio

http://msdn2.microsoft.com/en-us/library/aa188489(office.10).aspx

Additional query words: front page

Keywords: kberrmsg kbprb KB321493

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.