XL97: Microsoft Query 97 Does Not Support User and System DSNs

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q173521

Expand all | Collapse all

SYMPTOMS

In Microsoft Query 97, the Choose Data Source dialog box displays only File Data Source Names (DSNs).

Back to the top

This behavior is by design of Microsoft Query 97 for Windows.

This behavior has changed in Microsoft Query 97 that is installed with Microsoft Office 97 Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

151261 (http://support.microsoft.com/kb/151261/EN-US/ ) OFF97: How to Obtain and Install MS Office 97 SR-2

System and User DSNs appear in the Choose Data Source dialog box with asterisks (*). For example, a System or User DSN named My Data Source, appears as follows in the Choose Data Source dialog box:

My Data Source*

If your System and User DSNs are not visible in the Choose Data Source dialog box, follow these steps to make them visible:

Click Options in the Choose Data Source dialog box.
Click to select the "Include Registry DSNs in list of available databases" check box, and then click OK.

Back to the top

REFERENCES

For additional information, please see the following article in the Microsoft Knowledge Base:

159557 (http://support.microsoft.com/kb/159557/EN-US/ ) XL97: Using System, User, and File Data Sources

Back to the top

APPLIES TO

Microsoft Excel 97 Standard Edition
Microsoft Query 2000

Back to the top

kbinfo kbqfe KB173521

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top