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

• Microsoft Access 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 
Issue type        : kbprb 

Last Reviewed: April 6, 1999