<<<<    Connecting to non Oracle Databse from Oracle    >>>>
<<<<    Hetrogenius Connectivity                        >>>>

Non Oracle database & Oracle (Not Client) should be installed in the system
where you want to access the non oracle database ...


1)   Go To ODBC Datasource Administrator
     Create ODBC onnection
     Connection name here is --->>> DSLACCESS

2)   Go to Oracle_Home/NETWORK/ADMIN 
     Change the listner.ora 
   
      ********** 

      # listener.ora Network Configuration File: C:\ORACLE\network\admin\listener.ora
     # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = DSLACCESS)
          (ORACLE_HOME = C:\ORACLE)
          (PROGRAM = hsodbc )
           )
        (SID_DESC =
           (SID_NAME = DSLSBF)
           (ORACLE_HOME = C:\ORACLE)
           (PROGRAM = hsodbc )
         ) 
     )

   LISTENER =
      (DESCRIPTION_LIST =
       (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          (ADDRESS = (PROTOCOL = TCP)(HOST = snehatheeram.alshamali.com)(PORT = 1521))
     )
    )
  ******
  Here i am using 2 Handles 1 for Access other for Dbase

3) Go to ORACLE_HOME/hs/admin
   Change inithsodbc.ora
   As
   
   # 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 = DSLACCESS
   HS_FDS_CONNECT_INFO = DSLDBF
   HS_FDS_TRACE_LEVEL = off

   #
   # Environment variables required for the non-Oracle system
   #
   #set <envvar>=<value>
   
**********

4)  Go to ORACLE_HOME\NETWORK\ADMIN
    Change in tnsname.ora as follows
    
    DSLDATA =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST =  localhost)(PORT = 1521))
       (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = DSLACCESS)
       )
        (HS=OK)
      )

    DSLDBFDAT =
      (DESCRIPTION =
         (ADDRESS = (PROTOCOL = TCP)(HOST =  localhost)(PORT = 1521))
          (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = DSLDBF)
         )
          (HS=OK)
       )

     EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
       (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
       )
      (CONNECT_DATA =
        (SID = PLSExtProc)
      (PRESENTATION = RO)
       )
    )


5)****************
  Create Databse link
   Create database link MYDATABSELINK Connect to username identified
      by password using 'DSLACCESS'

6) Hoorayyyyyyyyy.U will get data now...