Solved

web page to tap into oracle

Posted on 2000-03-25
9
171 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
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
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In this Micro Tutorial viewers will learn how to create navigation buttons that change on rollover, using CSS (Continuation of the CSS Image Sprite tutorial) Create a parent ID for all the list items       - Specify position: absolute and display: block…
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…

773 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