XL2000: Edit Query Dialog Box Disappears When You Edit Oracle Query (322046)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Query
This article was previously published under Q322046 SYMPTOMS
When you use Microsoft Query in Microsoft Excel, and you try to edit a query that accesses data in an Oracle database, the Edit Query dialog box appears briefly and then disappears.
WORKAROUND
To work around this issue, use a System Data Source Name (DSN) instead of a File DSN when you set up your connection to the database. For additional information about how to create and use System DSNs, click the article numbers below
to view the articles in the Microsoft Knowledge Base:
213772 XL: How to Use System, User, and File Data Sources
300595 HOW TO: Create a System Data Source Name (DSN) in Windows 95, Windows 98, or Windows NT
300596 HOW TO: Create a System Data Source Name (DSN) in Windows 2000
305599 HOW TO: Create a System Data Source Name in Windows XP
| Modification Type: | Minor | Last Reviewed: | 1/6/2006 |
|---|
| Keywords: | kbnofix kbprb KB322046 |
|---|
|