Microsoft KB Archive/183050

= XL97: Queries No Longer Work After Upgrading Oracle ODBC Driver =

Article ID: 183050

Article Last Modified on 11/26/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Query 2000

-



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

Additional query words: XL97

Keywords: KB183050

-

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

© Microsoft Corporation. All rights reserved.