database link URGENT PLZ

  • From: "Waleed Haggagy" <haggagy@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 02 Mar 2004 07:57:35 +0200

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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: