Solved

web page to tap into oracle

Posted on 2000-03-25
9
177 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
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article discusses how to create an extensible mechanism for linked drop downs.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
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…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

636 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