asked on

web page to tap into oracle

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.

Daman

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

mafweb

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

jwei021000

ASKER

is there any way I could use VB and ODBC to do this?

ASKER CERTIFIED SOLUTION

ruperts

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jwei021000

ASKER

ruperts,
I was able to display my data using code from the simple display database example. Is using ADO the same as using ODBC?

ruperts

"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?)

jwei021000

ASKER

what's the relationship between ADO and ODBC?

ruperts

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.

jwei021000

ASKER

thanks!