MSQUERY: Available Data Sources List Empty

• Microsoft Query for Windows 95, version 2.0

SYMPTOMS

In Microsoft Query, when you click the New Query button or click New Query on the File menu, the Available Data Sources list in the Select Data Source dialog box may be empty.

CAUSE

This behavior occurs after you install Microsoft Query, using either the Microsoft Office version 7.0 Setup program or the Microsoft Excel version 7.0 Setup program. This behavior is by design of Microsoft Query. The list of data sources that Microsoft Query uses is different from the list of data sources that ODBC uses.

To view the list of data sources that ODBC uses, do the following:

1. In Microsoft Query, click New Query on the File menu.

2. In the Select Data Source dialog box, click Other.

RESOLUTION

To add a data source to the Available Data Sources list in Microsoft Query, do the following:

1. In Microsoft Query, click New Query on the File menu.

2. In the Select Data Source dialog box, click Other.

3. In the ODBC Data Sources dialog box, click the data source that you want to use. (Or click New to add a new data source.)

4. Click OK.

REFERENCES

For more information about adding a data source in Microsoft Query, click the Index tab in Microsoft Query Help, type the following text

   adding data