Heterogenous connectivity between Oracle and SQL Server 2000

From: <sanjeev.atvankar_at_gmail.com>
Date: 26 Mar 2007 00:26:18 -0700
Message-ID: <1174893978.105376.95810@b75g2000hsg.googlegroups.com>

Hello Gurus,

 I have the following things @ my site
 1> Oracle server on 10.103.123.83 m/c
 2> SQL Server 2000 on 10.103.123.83 m/c

 To achieve the Heterogenous connectivity between Oracle and SQL Server 2000 I follow the below Steps
Step 1> Create initABB.ora file in ..hs\admin folder and content will be as below

# This is a sample agent init file that contains the HS parameters
that are
# needed for an ODBC Agent.

#
# HS init parameters
#

HS_FDS_CONNECT_INFO = ABB
HS_FDS_TRACE_LEVEL = OFF Step 2> Add Listener entry into ..network\admin\listener.ora file

 LISTENERABB =

  (ADDRESS_LIST=
       (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522))
       (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

 SID_LIST_LISTENERABB=
   (SID_LIST=

       (SID_DESC=
          (SID_NAME=ABB)
          (ORACLE_HOME=D:\oracle\ora92\bin)
          (PROGRAM=hsodbc)
        )
       )

Step 3> Add service name entry into ..network\admin\tnsnames.ora file

ABB =
  (DESCRIPTION=

    (ADDRESS=(PROTOCOL=tcp)(HOST=10.103.123.83)(PORT=1522))
    (CONNECT_DATA=(SID=ABB))
    (HS=OK)

  )

Step 4> Fire the below command in command prompt

lsnrctl start listenerabb

Step 5> Fire the below command in command prompt

tnsping abb

Step 6> create Database Link using

create database link abb
connect to sa identified by sa using 'ABB';

Step 7> Check the connection from SQL Plus abb_sample is a table

desc abb_sample_at_abb

But got the Error as follows
ERROR:
ORA-28545: error diagnosed by Net8 when connecting to an agent NCRO: Failed to make RSLV connection
ORA-02063: preceding 2 lines from ABB

Thanking in Advance
Sanjeev Received on Mon Mar 26 2007 - 02:26:18 CDT