XL97: Queries No Longer Work After Upgrading Oracle ODBC Driver

ID: Q183050

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Query 97 for Windows

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:

Q165866 XL97: How to Use File DSNs and DSN-less Connections

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

Additional query words: XL97

Keywords : kbtool kbdta xlquery
Version : WINDOWS:
Platform : WINDOWS
Issue type :