Randy Rich
asked on
Best way to access an Oracle 8i database over the web
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Thanks
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.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 www.devart.com
the oracle client is an install option from the oracle cd
what are you using now to access the oracle db ?