Solved

web page to tap into oracle

Posted on 2000-03-25
9
176 Views
Last Modified: 2010-04-09
I'm trying to create a web page from which users can create, load, update, delete tables and create, update, and delete records in an oracle database. Can someone provide me with sample code on doing that? I'm using Oracle8i Lite.
0
Comment
Question by:jwei021000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 

Expert Comment

by:Daman
ID: 2658696
You have to work with JDBC (java database connectivity). Here you can have access to your database tables which you have designed using oracle. JDBC provide connectivity with oracle database support. For more information on JDBC vosit

http://java.sun.com or
http://java.sun.com/docs

Good Luck

0
 
LVL 1

Expert Comment

by:mafweb
ID: 2658876
Or you can use php3. It's got interfaces for the bigger db's, also for oracle. Have a look at http://www.php.net/manual/ref.oci8.php

hope this helps

Write if you need more info
0
 

Author Comment

by:jwei021000
ID: 2659502
is there any way I could use VB and ODBC to do this?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Accepted Solution

by:
ruperts earned 50 total points
ID: 2660168
ASP is way for a vb programmer you can use vb script to solve all your problems!

You can use you ODBC connection and ASP to generate dynamic web pages. To find out more try:

http://www.activeserverpages.com/learn

But you will need to run this on one of the following:
Win 95/98: Personal Web Server
NT: IIS
Linux: Chilli ASP.
0
 

Author Comment

by:jwei021000
ID: 2663238
ruperts,
I was able to display my data using code from the simple display database example. Is using ADO the same as using ODBC?
0
 
LVL 4

Expert Comment

by:ruperts
ID: 2663739
"ODBC - Open Database Connectivity. A specification for an API that defines a standard set of routines with which an application can access data in a data source."

Or simply, the ODBC references a database.

ADO is the method of accessing the database data, i.e. by using SELECT statements.

(Any help?)

0
 

Author Comment

by:jwei021000
ID: 2668066
what's the relationship between ADO and ODBC?
0
 
LVL 4

Expert Comment

by:ruperts
ID: 2668191
Database <-> ODBC <-> ADO <-> Your webpage

Although you don't always need the ODBC step, but you do need the ADO step.

So no ODBC is not the same ADO.



0
 

Author Comment

by:jwei021000
ID: 2671700
thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this. Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it i…
This article describes how to create custom column layout styles for Bootstrap. The article uses 5 columns to illustrate the concept, but the principle can be extended to any number of columns.
In this tutorial viewers will learn how add a scalable full-width header using CSS3. Create a new HTML document with an internal stylesheet. Set a tiled background.:  Create a new div and name it Header. Position it with position:absolute at the top…
In this tutorial viewers will learn how to embed Flash content in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <object> tag to embed Flash content.: To specify that the object is Flash content, d…

739 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