Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> HSOBCD connection to MSAccess DB problem

HSOBCD connection to MSAccess DB problem

From: Massi <maemoNOSPAN_at_libero.it>
Date: Fri, 21 Mar 2003 13:55:31 +0100
Message-ID: <3E7B0BC3.3040801@libero.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US