Best way to access an Oracle 8i database over the web

Posted on 2008-11-15
Last Modified: 2012-05-05
I have a windows application that I've developed using Delphi.  I'd like to be able to access an oracle 8i database over the web.  Most of the information will be read from the database (not written).  What way should I go?  3tier, ado, http, etc.

Question by:Randy Rich
    LVL 28

    Assisted Solution

    that's really your choice :) you need to consider:
    - what you know best (so in case there is a problem you can fix it)
    - what the computer you run it on wil have or will need
    - if this app will be used by many clients you will need an installer which will setup their PC so if you go with stuff that is generally not there on a regular windows PC you will need to either include it in the install kit, or have the installer download it from somewhere

    I personally prefer ADO (and ODBC in some cases), because:
    - it works with almost all DBMS (DataBase Management System)
    - ADO it's alreay installed on most computers
    - in case of ODBC all you need to distribute is the odbc connector (and not in all cases)
    - modifying the application to use another DBMS is usually done just by changing the connection string (there are some stuff private to a specific DBMS but that is usually easy to spot when you do a simple test of everything :) ). So basically you don't need to rewrite the whole DB thing

    so all you need to download and install in case of ado with odbc for oracle is the odbc driver
    I don't know about oracle, but I think the oldest one should work with oracle 8i (and maybe the newer ones too. you'll need to read theiur specs and see which one is better for you)
    if you plan on using the one coming with windows, you should read the following KB just in case you don't mess things up:
    Obviously, there are other drivers as well, but I haven't used any other.
    LVL 36

    Expert Comment

    by:Geert Gruwez
    it depends if you have direct access to the oracle database or not.
    if your database is only accessible from the webserver then you need to write a web application
    otherwise i would install the oracle client (the latest one (9, 10, 11) is backward compatible with 8)
    i use odac components for access to the oracle database from
    the oracle client is an install option from the oracle cd
    what are you using now to access the oracle db ?


    Author Comment

    by:Randy Rich
    Currently I'm using ASTA which is a 3 tier client server.  The asta server handles all of the work on the server side.  It communicates with sql net and transfers the information out across the Internet via http.  On the client side you use the asta client which is built into your application.
    The only problem with this arrangement is that the asta server tends to lock up.  I've contacted the company, but to date they really haven't offered any solutions.  I'm really looking for something that will give me the same functionality, but using a more stable platform with better support.  I figured that .net may have something built in to provide 3-tier or something like it.
    One thing that I like is the ability to just launch the application on the client side with a minium amount of installation.  In other words there is little to deploy.  Does this mean that I should stick with the 3-tier model and if so, what vendor should I choose?  I don't want to have to install the Oracle client on every user's machine.
    LVL 36

    Accepted Solution

    then you only need to change the server tier
    the client should stay the same as it doesn't know of any database.

    if it's ASTA :
    then they can allready use DOA (Direct Oracle Access)

    if you want a minimal client side install then stick to this 3 tier

    this has a list of alternatives:

    otherwise, hope ASTA fixes the problems in a new release
    although they don't seem to be changing a lot on their site lately:
    ASTA: Last modified: 1/28/2006 5:08:34 AM


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now