Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Unanswered: Not sybase specific but.......

    I have been tasked to write an interface between sybase database and an oracle database that picks up a string of data (already created in a view) from a single primary field. Any pointers as to where I can get some info from the bottom up.
    Last edited by Bizw0z; 11-11-02 at 11:52.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya

    You can try Power Builder, there is a eval available on Sybase site.

    Cheers
    Willy

  3. #3
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Re: Not sybase specific but.......

    Sybase have a product called Direct Connect for Oracle (DCO). You can then use proxy tables to access the Oracle server.

    You send SQL to ASE
    ASE identifies the table is a proxy table and sends it to DCO
    DCO connects to the Oracle server using SQL*NET (or whatever they use these days)
    Oracle server processes the query and sends it back to DCO
    DCO passes it back to the ASE
    ASE passes it back to you.

    Direct Connect for Oracle creates another process that the ASE can communicate with. DCO acts as a server for Sybase and a client for Oracle.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •