DOCUMENT:Q321493 06-AUG-2002 [frontpg] TITLE :FP: Err Msg: PivotTable List Could Not Connect to Data Source PRODUCT :Word Front Page PROD/VER:: OPER/SYS: KEYWORDS:kberrmsg kbdta ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft FrontPage 2002 - Microsoft FrontPage 2000 ------------------------------------------------------------------------------- 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: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified." 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: 1. Create a share for the database on the server. 2. Assign appropriate permissions to users to access the share. 3. 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: Q265034 FP2000: How to Change from File DSN to System DSN in FrontPage Q305599 HOW TO: Create a System Data Source Name in Windows XP 4. Configure the PivotTable component to connect to the System DSN that you created in step 3: a. Start FrontPage, and then open the page that contains the PivotTable component. b. On the PivotTable toolbar, click Property Toolbox. c. Click Data Source, click Connection, and then click Connection Editor. d. Click the Provider tab. e. In the OLE DB Provider(s) list, click "Microsoft OLE DB Provider for ODBC Drivers", and then click Next. f. 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. g. Click "Data member" under "User data from" in the PivotTable Property Toolbox dialog box, and then click the database element that you want. h. Close the PivotTable Property Toolbox dialog box. On the Client Computer: 1. Install Microsoft Office XP or Microsoft Office 2000 (if it is not already installed). 2. Map a drive to the share on the server that contains the database. For example, \\\. 3. 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: Q265034 FP2000: How to Change from File DSN to System DSN in FrontPage Q305599 HOW TO: Create a System Data Source Name in Windows XP 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: 1. Create a share for the database on the server. 2. 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: Q265034 FP2000: How to Change from File DSN to System DSN in FrontPage Q305599 HOW TO: Create a System Data Source Name in Windows XP 3. Create and configure the System DSN for the database. 4. Configure the PivotTable component to connect to the System DSN that you created in step 3: a. Start FrontPage, and open the page that contains the PivotTable component. b. On the PivotTable toolbar, click Property Toolbox. c. Click Data Source, click Connection, and then click Connection Editor. d. Click the Provider tab. e. In the OLE DB Provider(s) list, click "Microsoft Jet 4.0 OLE DB Provider", and then click Next. f. Under "Select or enter a database name", type the UNC path to the database. For example, type "\\ServerName\ShareName\Database.mdb" (without the quotation marks), and then click OK. g. Click "Data member" under "User data from" in the PivotTable Property Toolbox dialog box, and then click the database element that you want. 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. 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 "Microsoft Office 2000 Web Components Basics" article: Microsoft Office 2000 Web Components Basics http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2kta/html/msowcbasics.asp For more information about how to work with Office 2000 Web components, visit the following Microsoft Web site, and then see the "Office Web Components" section: Microsoft Office Development with Visual Studio http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffdev/html/vsofficedev.asp Additional query words: front page ====================================================================== Keywords : kberrmsg kbdta Technology : kbFrontPageSearch kbFrontPage2002 kbFrontPage2000Search kbFrontPage2002Search kbZNotKeyword5 Version : : Issue type : kbprb ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2002.