Managing Heterogeneous Services Using Generic Connectivity

From: andrija <ar35644_at_fer.hr>
Date: Wed, 19 Dec 2001 14:12:47 +0100
Message-ID: <9vq3ou$2mbl$1_at_as201.hinet.hr>


I'm trying to connect Oracle over ODBC to another database (for testing I use MS SQL Server 7.0).
OS is Windows 200 Professional.

I have checked in SYS schema and there exist needed objects (HS_*).

I have configured listener.ora and tnsnames.ora and restarted listener. I have also created system DSN MSSQL. Checked connection and connection to SQL Server is OK.

Here is what I added in listener.ora:

LISTENER=
      (DESCRIPTION LIST =
(...)

        (ADDRESS_LIST=
            (ADDRESS = (PROTOCOL = ipc )(KEY = PNPKEY))
       )

(...)

SID_LIST_LISTENER =
     (SID_LIST =
   (...)

         (SID_DESC=
              (SID_NAME = MSSQL)
              (ORACLE_HOME = C:\Oracle\Ora81)
              (PROGRAM = hsodbc)
         )
      )



in tnsnames.ora I have, among other things:

mssql = (DESCRIPTION =

                  (ADDRESS = (PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
                  (CONNECT_DATA=(SID=MSSQL))
                   (HS = OK)
               )



I also have initMSSQL.ora file in c:\Oracle\Ora81\hs\admin folder:

HS_FDS_CONNECT_INFO= MSSQL when I try from command prompt:

tnsping mssql

It 'pings' it ok.

But where I create database link, test says 'The Database Link is not active'.
When i try from SQLPLUS something like

select * from table_at_mssql;

I get the message:

database link mssql connects to HO.WORLD. Received on Wed Dec 19 2001 - 14:12:47 CET

Original text of this message