OFF97: Complete Setup Doesn't Install All ODBC Drivers

Last reviewed: March 12, 1998
Article ID: Q156835
The information in this article applies to:
  • Microsoft Office 97 for Windows
  • Microsoft Excel 97 for Windows
  • Microsoft Word 97 for Windows
  • Microsoft PowerPoint 97 for Windows
  • Microsoft Access 97 for Windows

SYMPTOMS

When you perform a complete installation of Microsoft Office 97, not all of the included ODBC (Open Database Connectivity) drivers are installed. Specifically, the following ODBC drivers are not installed:

   Paradox Driver
   Lotus 1-2-3 Driver
   Exchange Driver
   SQL Server Driver

CAUSE

This occurs because some drivers have been moved from the main Microsoft Office 97 Setup program into the Microsoft Data Access Pack, included in the Microsoft Office Value Pack. A separate Setup program must be run in order to install these drivers.

RESOLUTION

To install the aforementioned ODBC drivers, follow these steps:

  1. Insert your Microsoft Office 97 disc into your CD-ROM drive, or, if you installed Microsoft Office 97 from a network server, connect to the network server.

  2. On the Start menu, click Run. Type the following command line:

          <X>:\Valupack\Dataacc\Dataacc.exe
    

    where <X> is the letter of your CD-ROM drive. Or, type the path that points to the Dataacc.exe file on your network server.

    Then, click OK.

  3. Click Yes to install the Microsoft Data Access Pack.

  4. When the Data Access Setup dialog box appears, click Continue. If you are warned that the Data Access Pack has already been installed, click Continue.

  5. Click OK to allow the Setup program to copy the data access files to the C:\Program Files\Data Access folder. Or, click "Change Folder" to specify a different path, and then click OK.

  6. Click "Complete\Custom Install".

  7. Click "Change Option". In the next dialog box, select the checkbox for each driver you want to install.

  8. Click OK and then click Continue.

  9. When Setup has copied all the files, you should receive the message "Data Access Pack Setup was completed successfully." Click OK.

MORE INFORMATION

The Microsoft Data Access Pack included with Microsoft Office 97 includes several different ODBC drivers. The following table lists these drivers and whether or not they are installed when you perform a complete installation of Microsoft Office:

                                         Installed With a
   Driver                             Complete Office Install
   ----------------------------------------------------------

   Microsoft Access Driver                      yes
   Microsoft Excel Driver                       yes
   Microsoft Text and HTML Driver               yes
   Microsoft xBase Driver                       yes
   Exchange Driver                              no
   Paradox Driver                               no
   Lotus 1-2-3 Driver                           no
   SQL Server Driver                            no


The first four drivers listed in the table above are installed during a complete setup of Microsoft Office 97, but are also included in the Data Access Pack. The last three drivers listed in the above table are included only in the Data Access Pack.

Because the drivers in the Data Access Pack are installed by a separate Setup program, it is not possible to incorporate these drivers into an administrative installation ("setup /a") of Microsoft Office 97. You must run the Dataacc.exe program to install the additional drivers.


Additional query words: OFF97 XL97 dbase custom value pack valuepak
Keywords : offvalpak OffWinSetup xlquery kbprb kbsetup
Version : WINDOWS:97
Platform : WINDOWS


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.

Last reviewed: March 12, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.