ACC2: "ORA-9241" Error Deleting and Then Attaching ORACLE Table

Last reviewed: May 20, 1997
Article ID: Q119470

The information in this article applies to:

Microsoft Access version 2.0

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

If you attach several ORACLE tables, delete a table, then immediately attach another ORACLE table, you receive the following error message when you try to log in to the table:

   [Microsoft][ODBC DLL] Driver's SQLSetConnectOption failed (#0)
   [PageAhead][ODBC Oracle Driver]Driver not capable. (#0)[PageAhead]
   [ODBC Oracle Driver][Oracle OCI] ORA-09241: Message not found;
   product=RDMS; facility=ORA; language=NULL. (#9241)

CAUSE

Preliminary tests indicate that this behavior is due to the ORACLE 6.0 ODBC driver. The ORACLE 7.0 ODBC driver does not exhibit this behavior.

According to ORACLE's error documentation, the ORA-9241 error message means "ss_tln: error translating logical name," which indicates that an error occurred in the low-level network communication process, such as an environment configuration problem or a lack of file handles.

RESOLUTION

If you are running an ORACLE 7.0 server, you can work around this behavior by obtaining the ORACLE 7.0 ODBC driver.

You can purchase it from Intersol (formerly Q+E).

If you are running an ORACLE 6.0 server, there is currently no workaround other than upgrading the server to ORACLE version 7.0 and using the ORACLE 7.0 ODBC driver.

MORE INFORMATION

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

Keywords : kberrmsg kbusage OdbcOracl
Version : 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 20, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.