Oracle DB with Pro/5

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Dominic
    #1

    Oracle DB with Pro/5

    Hi,

    I am TOTALLY new to all this stuff and really hope to find help here.

    I have to come up with a solution for one of my client.


    They use HP-UX and Pro/5

    What I'm trying to do:
    Using Pro/5. Make a SQL ( select ) statement to an ORACLE database.


    What I need to know and do:
    - Find an OBDC driver that will allow me to connect to the ORACLE database.
    - Configure what file ? ( config.tpm, obdc.ini, sql.ini ) are all these
    files important ?? What should they look like ? Have any example of those
    file for an Oracle database.

    =============== ===========
    I just need to install a simple test oracle database and query a table from
    pro/5.

    All this is so new, my question might seem to much work to explain, but I
    read a lot on many website, but can't make things to work ... can't find an
    obdc .. don't know how to configure it anyway ... I need help please.

    I know it is possible to query an Unix-Oracle Database from Pro/5 (NOT
    VPRO5) , I just need help of someone who did this already.




    Thanks !
    Dominic

    dbelley@cosotec h.com




    Tags: None
    • Peter Murray
      #2
      Re: Oracle DB with Pro/5

      Hi Dominic,

      If you have the Oracle CD and have installed Oracle client libraries, an
      ODBC driver should come with it. Alternatively, you can download a
      driver from DataDirect (http://www.datadirect.com). Their drivers do not
      require Oracle's client libraries however these drivers will cost you $500.

      You could also try WinSQL (http://www.synametrics.com) that comes with
      Oracle's Driver and can be used to test your connectivity.

      Regards,
      PM

      Dominic wrote:
      Hi,
      >
      I am TOTALLY new to all this stuff and really hope to find help here.
      >
      I have to come up with a solution for one of my client.
      >
      >
      They use HP-UX and Pro/5
      >
      What I'm trying to do:
      Using Pro/5. Make a SQL ( select ) statement to an ORACLE database.
      >
      >
      What I need to know and do:
      - Find an OBDC driver that will allow me to connect to the ORACLE database.
      - Configure what file ? ( config.tpm, obdc.ini, sql.ini ) are all these
      files important ?? What should they look like ? Have any example of those
      file for an Oracle database.
      >
      =============== ===========
      I just need to install a simple test oracle database and query a table from
      pro/5.
      >
      All this is so new, my question might seem to much work to explain, but I
      read a lot on many website, but can't make things to work ... can't find an
      obdc .. don't know how to configure it anyway ... I need help please.
      >
      I know it is possible to query an Unix-Oracle Database from Pro/5 (NOT
      VPRO5) , I just need help of someone who did this already.
      >
      >
      >
      >
      Thanks !
      Dominic
      >
      dbelley@cosotec h.com
      >
      >
      >
      >

        Comment

        Previous template Next
        Working...