Re: Heterogenous connectivity between Oracle and SQL Server 2000

sanjeev.atvankar_at_gmail.com wrote:
> 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

Seems you missed to define an ODBC Datasource (sqlserver) named ABB.

regards

s.kapitza Received on Mon Mar 26 2007 - 02:44:24 CDT