Microsoft KB Archive/229171

= Data Source Name May Not Be Displayed =

Article ID: 229171

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Windows 98 Second Edition
 * Microsoft Windows 98 Standard Edition

-



This article was previously published under Q229171



SYMPTOMS
When you attempt to connect to an external data source using Microsoft Query version 2.0 and Microsoft SQL Server version 6.5 or 7.0, the data source name may not be displayed.



CAUSE
This problem can occur after Microsoft Data Access Components (MDAC) is updated to a newer version that is not compatible with Query version 2.0.



RESOLUTION
To resolve this problem, install the Office 95 Year 2000 Update from the following Microsoft Web site:

http://office.microsoft.com

To work around this problem, create a new Data Source Name (DSN):
 * 1) Click Start, point to Settings, and then click Control Panel.
 * 2) Double-click ODBC Data Sources (32bit).
 * 3) Click the File DSN tab.
 * 4) Click Add.
 * 5) Click SQL Server, and then click Next.
 * 6) Follow the instructions on the screen to finish.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
This problem occurs only when the DSN is listed on the File DSN tab. The information on the File DSN tab is not used in Query version 2.0 or Microsoft Office 7.0 for Windows 95. This information is used in Microsoft Office 97.

Keywords: kbdownload kbinterop kbprb KB229171

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.