database link URGENT PLZ

From: Waleed Haggagy <haggagy_at_hotmail.com>
Date: Tue, 02 Mar 2004 07:57:35 +0200
Message-ID: <BAY1-F10hjx7ciQ7SBZ0000696a@hotmail.com>

thx Tanel for yr replay,
i do what u said,
but it is not working

plz check my code for connect to db2 on as400 (aserver is odbc connection to db2)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = hsodbc)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = hsodbc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = ORCLSURV)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = ORCLSURV)

    )
  )

HSODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = LOCALHOST)(PORT = 1521))

     )
     (CONNECT_DATA =
       (SERVICE_NAME = hsodbc)
     )
     (HS = OK)

)

# 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 = ASERVER

HS_AUTOREGISTER = TRUE
HS_DB_NAME = HSODBC
#HS_FDS_TRACE_LEVEL = 0
# HS_FDS_TRACE_FILE_NAME = hsodbc.trc

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

_________________________________________________________________

Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 01 2004 - 23:58:38 CST