Data Source Name May Not Be Displayed

ID: Q229171

The information in this article applies to:

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://officeupdate.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 this to be a problem in the Microsoft products 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.

Additional query words: 


Keywords          : kbinterop win98 win98se 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: June 8, 1999