Microsoft KB Archive/119470

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

Article ID: 119470

Article Last Modified on 11/6/2000

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q119470



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 kbprb kbusage KB119470

-

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

© Microsoft Corporation. All rights reserved.