ID: Q183050
The information in this article applies to:
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.
In Microsoft Query 97, the Choose Data Source dialog box displays only File Data Source Names (DSNs).
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.
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.
This behavior is by design of Microsoft Query 97 for Windows.
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:
ARTICLE-ID: Q165866
TITLE : XL97: How to Use File DSNs and DSN-less Connections
ARTICLE-ID: Q159557
TITLE : XL97: Using System, User, and File Data Sources
Keywords : kbtool kbdta xlquery
Version : WINDOWS:97
Platform : WINDOWSLast Reviewed: November 5, 1998