Managing Heterogeneous Services Using Generic Connectivity
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