Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> HSOBCD connection to MSAccess DB problem
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_at_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))) On another PC, the same operation works, so I think it is a installation-configuration Oracle problem.
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:\oracle\ora901)
(PROGRAM=hsodbc)
)
)
Thanks for any suggestions
Massi
Received on Fri Mar 21 2003 - 06:55:31 CST