Data Source Name May Not Be Displayed (229171)
The information in this article applies to:
- Microsoft Windows 98 Second Edition
- Microsoft Windows 98
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:
To work around this problem, create a new Data Source Name (DSN):
- Click Start, point to Settings, and then click Control Panel.
- Double-click ODBC Data Sources (32bit).
- Click the File DSN tab.
- Click Add.
- Click SQL Server, and then click Next.
- Follow the instructions on the screen to finish.
STATUSMicrosoft 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.
| Modification Type: | Minor | Last Reviewed: | 12/20/2004 |
|---|
| Keywords: | kbdownload kbinterop kbprb KB229171 |
|---|
|