XL97: Microsoft Query 97 Does Not Support User and System DSNs
Article ID: 173521
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Query 2000
This article was previously published under Q173521
SYMPTOMS
In Microsoft Query 97, the Choose Data Source dialog box displays only File
Data Source Names (DSNs).
STATUS
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 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:
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.
REFERENCES
For additional information, please see the following article in the
Microsoft Knowledge Base:
159557 XL97: Using System, User, and File Data Sources
Keywords: kbinfo kbqfe KB173521