Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 9th, 2007, 06:41 AM
Authorized User
 
Join Date: Aug 2006
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP login script with Oracle Database

Hi,

I am new to this area.

Can anyone help me please.

How can I set up login screen in ASP 3 (Not .Net) based on Oracle database username and password?

Thanks in Advance.

Thamil

 
Old March 9th, 2007, 08:04 AM
Authorized User
 
Join Date: Jan 2007
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to saurabhj Send a message via Yahoo to saurabhj
Default

http://www.evolt.org/node/28652

-Saurabh
 
Old March 9th, 2007, 11:43 AM
Friend of Wrox
 
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Thamil,

What part of this do you need help with?

A login screen is merely an html page with a form that can be submitted with whatever input is needed to log someone in to your site - usually a unique user name and a password, but can contain other info as requried.

Once you submit that info, you need to "authenticate" the user as being someone who is a "member" - this is often done using a table in the database. If the proper info has been entered, your app would typically set a session variable that is used to indicate the user has been given access to the site or part of the site(authorized). You can also use cookies or hidden variables to pass from request to request that the user is "logged on" but it is most common to use a session variable.

Connecting to an Oracle database is about the same as connecting to any database.

So, specifically, what part of this are you having trouble with?

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems
 
Old March 12th, 2007, 08:04 AM
Authorized User
 
Join Date: Aug 2006
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dear Friends,

Thanks for your replies.

The scenario is:
I wanted to check username and password in asp or html based on oracle Database login credentials, Database doesnt have a separate column for password, but it does have a column for usernames.
I think the passwords stored somewhere in Oracle Server.

Thanks for your interest in my post.

Thamil

 
Old March 12th, 2007, 11:01 AM
Friend of Wrox
 
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Interesting. In that case, I will have to defer to someone more expert in Oracle database login credentials. However, one way to approach this might be to simply attempt to login to the Oracle database with the provided name and password - if it succeeds, then you accept the user as authenitcated, if not, you reply that their login is incorrect.

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems
 
Old March 13th, 2007, 04:50 AM
Authorized User
 
Join Date: Aug 2006
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks very much.

Thamil






Similar Threads
Thread Thread Starter Forum Replies Last Post
Runing package script for Oracle Database Installe navedkhan ADO.NET 0 February 28th, 2007 04:33 AM
login script: user can't hit "return" for login dmerrill Java Basics 13 July 14th, 2006 07:25 PM
login script jstewie Javascript How-To 1 July 13th, 2005 12:52 PM
Connecting Oracle Database with an ASP page krisvamshi Oracle ASP 3 November 14th, 2004 05:56 PM
Create Oracle database using a script pankaj_daga Oracle 2 June 22nd, 2004 07:13 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.