hsolesql

From: Ralf Pickel <ralf.pickel_at_pdv.de>
Date: Tue, 10 Apr 2001 16:29:23 +0200
Message-ID: <3ad31892$0$1690$4dbef881@businessnews.de.uu.net>

Oracle8i 8.1.7, Windows 2000 Server

I'm getting the following error message during my attempt to connect to an local SQL Server with generic connectivity:

HS: Agent unable to establish RPC service context HS: ... NCR error = 3018

My tnsnames.ora looks like this:

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools.

INST1_HTTP.xxx =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = standard.xxx)
(PRESENTATION = http://admin)

    )
  )

EXTPROC_CONNECTION_DATA.xxx =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

STANDARD.xxx =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = standard.xxx)

    )
  )

SQL7.xxx =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = sql7)

    )
    (HS = OK)
  )

The listener.ora :

# LISTENER.ORA Network Configuration File: C:\oracle\ora81\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 2481))
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = IS0))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = standard.xxx)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = standard)

    )
    (SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)

    )
    (SID_DESC =
(PROGRAM = hsolesql)
(SID_NAME = sql7)
(ORACLE_HOME = C:\oracle\ora81)

    )
  )

The initsql7.ora :

HS_FDS_CONNECT_INFO = "UDLFILE=sql7.udl" HS_FDS_TRACE_LEVEL = OFF The sql7.udl :
[oledb]
; Everything after this line is an OLE DB initstring Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=xxx

All files are in "network\admin".

Can anyone help me ?

Ralf Received on Tue Apr 10 2001 - 09:29:23 CDT