ACC2: "ORA-9241" Error Deleting and Then Attaching ORACLE Table
ID: Q119470
|
The information in this article applies to:
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