How to Tell If ODBC Is Installed Correctly

Last reviewed: February 6, 1998
Article ID: Q109567
The information in this article applies to:
  • Microsoft Word for Windows versions 6.0, 6.0a
  • Microsoft Windows operating system versions 3.0, 3.1

SUMMARY

Word for Windows uses the Open Database Connectivity (ODBC) drivers to access data from database management system files. The ODBC drivers are installed during a Complete setup of Word 6.0 for Windows. To verify that the ODBC drivers have been installed, attach a database data file to a main document with Confirm Conversions turned on. If the drivers are installed, the following will appear in the Confirm Data Source dialog box:

   <Database name> via ODBC.

If the ODBC drivers and ODBC driver manager have been properly installed by Word 6.0 for Windows, an icon for ODBC will appear in the Windows Control Panel. If you choose this icon, the Data Sources dialog box appears, which should list the following data sources:

   dBASE Files (dBASE Files (*.dbf))
   FoxPro Files (FoxPro Files (*.dbf))
   MS Access Databases (Access Data (*.mdb))
   Paradox Files (Paradox Files (*.db))

MORE INFORMATION

The following are the files required to run ODBC:

   ODBC.DLL
   ODBCINST.DLL
   ODBC.INF
   SIMBA.DLL
   SIMADMIN.DLL
   MSJETDSP.DLL

The ODBC Installation Help file, ODBCINST.HLP is not required.

The following are ODBC drivers shipped with Word 6 for Windows:

   DRIVER                APPLICATION
   ------                -----------
   XBS110.DLL            dBASE and Fox driver
   RED110.DLL            Access driver
   PDX110.DLL            Paradox driver

To Install ODBC

  1. Run Setup for Word 6.0 or 6.0a for Windows.

  2. Choose Add/Remove.

  3. Choose Conversions/Filters and Data Access.

  4. Select Data Access ODBC.

To Configure ODBC to Work with Word 6.0

Once ODBC is installed, the drivers must appear in the ODBC Administrator in Windows Control Panel. To set up an ODBC Data Source, do the following:

  1. Run Windows Control Panel and choose the ODBC icon.

  2. If the Data Source is not on the list, choose Add.

  3. From the Installed ODBC Drivers list, select a driver, and choose OK.

  4. Type in a descriptive Data Source Name--this can be any text--and then choose OK.

  5. Select Use Current Directory and choose OK.

REFERENCES

"Microsoft Word Quick Results," page 11


KBCategory:
KBSubcategory:
Additional query words: 6.0 6.0a odbc winword word6
Keywords : kbsetup
Version : 6.0 6.0a
Platform : WINDOWS
Issue type : kbhowto


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: February 6, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.