login page

[chets92]

sir
I have two text box and two buttons.The first text box is for the username
and the second for the password.The first button(ok) is is to check wether the entered user name, password is valid or not..if not i want it to display a message.if the password is valid i want the next page to be shown..i'm using vb6 as i'm front end and oracle 9i as my backend.i'm working on windows xp..
can u also please mention what are the changes i have to make in order for the user name and password to be checked from oracle database...shou ld i create some tables and do some sort of connections...

[debasisdas]

1.create a table in oracle.
2. store the username and password.
3.connect to oracle from VB.
4.check for existance of the username and the corresponding password.

if that exists allow to login and move to next page else reprompt for correct username and password .

[chets92]

sir
can i have the code for vb and oracle to create the login page

[debasisdas]

sir
can i have the code for vb and oracle to create the login page

can you post what you have tried so far.

select login dialog from add form .

you will get the basic idea how to do all that.

[chets92]

sir i'm a laymen....all i have done is designed the form..
can u please help me..i don't know anything about connecting oracle 9i to vb

[debasisdas]

please find the connection details here .

[chets92]

which one should i enter for oracle9i ..where to enter this connection string in the form or somewhere else

[debasisdas]

which one should i enter for oracle9i ..where to enter this connection string in the form or somewhere else

1.you need to use ADODB for connection to dadtabase
2.create connection and recordset object.
3.open the recordset with query and check of the username password already exists in database
4.proceed further.

[chets92]

thank u sir
how can i import icons onto my form....ie on top of my command button