By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,953 Members | 1,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,953 IT Pros & Developers. It's quick & easy.

login page

P: 11
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...should i create some tables and do some sort of connections...
Jul 15 '08 #1
Share this Question
Share on Google+
8 Replies


debasisdas
Expert 5K+
P: 8,127
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 .
Jul 15 '08 #2

P: 11
sir
can i have the code for vb and oracle to create the login page
Jul 16 '08 #3

debasisdas
Expert 5K+
P: 8,127
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.
Jul 16 '08 #4

P: 11
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
Jul 17 '08 #5

debasisdas
Expert 5K+
P: 8,127
please find the connection details here .
Jul 17 '08 #6

P: 11
which one should i enter for oracle9i ..where to enter this connection string in the form or somewhere else
Jul 18 '08 #7

debasisdas
Expert 5K+
P: 8,127
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.
Jul 18 '08 #8

P: 11
thank u sir
how can i import icons onto my form....ie on top of my command button
Jul 21 '08 #9

Post your reply

Sign in to post your reply or Sign up for a free account.