XL97: Queries No Longer Work After Upgrading Oracle ODBC Driver (183050)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Query
This article was previously published under Q183050
WARNING: The information in this article has not been confirmed or tested by Microsoft. Some or all of the information in this article has been taken from unconfirmed customer reports. ANY USE BY YOU OF THE INFORMATION PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this information "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

SYMPTOMS

In Microsoft Query 97, the Choose Data Source dialog box displays only File Data Source Names (DSNs).

CAUSE

This problem occurs when you upgrade the existing Intersolv Oracle 3.00 Open Database Connectivity (ODBC) driver to the Intersolv Oracle 3.01 ODBC driver.

WORKAROUND

To work around this behavior, use the updated driver and re-create all queries that you have previously created with the Oracle 3.00 ODBC driver.

STATUS

This behavior is by design of Microsoft Query 97 for Windows.

MORE INFORMATION

The Oracle 3.01 ODBC driver stores the version number as part of the driver name. DSN-less connections, which are used by Microsoft Query 97, store the driver name as part of the connection string. When the Oracle driver version number changes, so does the driver name, which invalidates the existing connection string.

The Oracle ODBC driver is manufactured by Intersolv, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

For additional information on creating DSNs, please see the following articles in the Microsoft Knowledge Base:

165866 XL: How to Use File DSNs and DSN-less Connections

159557 XL97: Using System, User, and File Data Sources

Modification Type:MajorLast Reviewed:11/26/2001
Keywords:KB183050
©2002 Microsoft Corporation. All rights reserved.