Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

web page to tap into oracle

Posted on 2000-03-25
9
Medium Priority
?
179 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 4

Accepted Solution

by:
ruperts earned 150 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Find out what you should include to make the best professional email signature for your organization.
Originally, this post was published on Monitis Blog, you can check it here . Websites are getting bigger and more complicated by the day. Video, images and custom fonts are all great for showcasing your product or service. But the price to pay in…
In this tutorial viewers will learn how to style elements, such a divs, with a "drop shadow" effect using the CSS box-shadow property Start with a normal styled element, such as a div.: In the element's style, type the box shadow property: "box-shad…
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…

670 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