Oracle web coding

[david902]

believe me I am no Oracle Expert, I'm a network guy,

I used to work for a s/w development company that
would take web form data and put that data into an Oracle database, I'm now at a new company trying to make recommendations that it's fairly simple to put web form data into an oracle database, ( given the right ODBC connections)

our Oracle person is not a web person, and it's very difficult to try to explain what I am trying to accomplish.

what i'm looking for are snippets of code that would help in explaining how the Oracle programmer would go about putting web data into an Oracle database.


Thanks.

 

[david902]

maybe I should add this the web server is NT 4.0, IIS
the Oracle datbase is 8i, also running on NT 4.0

 

[nme]

I think you want to look on an ASP site for help - I'm sure there will be an ASP forum on Tek-tips.

If not try

http://www.asp101.com,

I had a quick look on there and there is a page that would get you started (it uses an Access database, but you can easily change the ADO provider to look for an ODBC connector to point to an Oracle database, you should read up on ADO).

Here's the direct link:

http://www.asp101.com/samples/login.asp#dbconnected

There's a bit at the bottom about not hard-coding the password, this has a link that will show you an ASP form that goes to a database.

There are others, and this is just a starting point - you would also be wise to look on Microsoft's web site as it usually has enough info to take and configure to fit your own requirements.


Please note - I am not advocating ASP - I prefer JSP, but ASP is already integrated into IIS, and so you won;t have to sort out a JSP plugin.