Re: Heterogeneous Service Setup: SQL Server link fails

learning_still_at_hotmail.com (Newbie) wrote in message news:<6093c29e.0407140738.255ce90f_at_posting.google.com>...
> Hi,
>
> I've to setup and use SQL Server 2K db from O9i db. Basically, i've to
> periodically PULL data from SS2K into O9i tables.
>
> Have done the necessary setup as specified in Oracle docs.
>
> 1. System DSN: SQLServer2K
>
> 2. ini file: initSQLServer2K.ora
> contents of ini file
> HS_FDS_CONNECT_INFO = SQLServer2K
> HS_FDS_TRACE_LEVEL = 0
>
> 3. tnsnames entry:
> SQLServer2K =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = PC-P3654)(PORT = 1433))
> )
> (CONNECT_DATA =
> (SID = SQLServer2K)
> )
> (HS = OK)
> )
>
>
> 4. listener.ora entry
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = E:\OraHome1)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = emfg)
> (ORACLE_HOME = E:\OraHome1)
> (SID_NAME = emfg)
> )
> (SID_DESC =
> (SID_NAME = SQLServer2K)
> (ORACLE_HOME = E:\OraHome1)
> (PROGRAM = hsodbc)
> )
> )
>
>
> Did i miss something here? Coz when trying to connect to the tables in
> SS2K, get following error:
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
>
> SQL> select * from currency_at_sqlserver2k;
> select * from currency_at_sqlserver2k
> *
> ERROR at line 1:
> ORA-28545: error diagnosed by Net8 when connecting to an agent
> NCRO: Failed to make RSLV connection
> ORA-02063: preceding 2 lines from SQLSERVER2K
>
>
> I'm not able to figure out where the error lies.
>
> Any inputs on this??
>
> TIA
check if your listner is configured for port 1433 or change your tns to your configured port. (btw. standart is 1521)

regards

s.kapitza Received on Thu Jul 15 2004 - 10:46:35 CDT