| HS from MSAccess connection failure [message #66939] |
Wed, 19 March 2003 09:49 |
Massimo
Messages: 1
Registered: March 2003
|
Junior Member |
|
|
I'm trying to connect to a MSAccess DB using hetereogeneous services.
When I try to retrieve data from this DB I receive this error message:
select * from table1@cti
*
ERROR at line 1:
ORA-02068: following severe error from CTI
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521
)))(CONNECT_DATA=(SID=CTI)))
The entry in the tnsnames.ora is:
HSCTI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = CTI)
)
(HS = OK)
)
and the entry in listener.ora is:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CTI)
(ORACLE_HOME = d:oracleora901)
(PROGRAM=hsodbc)
)
)
Thanks for any suggestions
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
