Knowledge Base |

# 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