How to Tell If ODBC Is Installed Correctly

ID: Q109567

The information in this article applies to:

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.

1. Choose Add/Remove.

2. Choose Conversions/Filters and Data Access.

3. 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

Last Reviewed: February 6, 1998