How to code for a login form by taking data from Oracle db?

hello frnz...How to code for a login form by taking data from Oracle db?
M having a table Employee having attribute as emplogin and emppwd...from there i want to check that whether the user has entered the correct data or not...
I mean i want to match the entered data with that of the data in database.
Plz help me out with this...as m new to VB6.

You need an ADO Connection object and a Recordset object .
First open the Connection to the Oracle database.
and open a Recordset with this Query:
"Select * From Login_Info_Table Where UserName = '" & txtUser.Text & "'" And Pwd = "'" & txtPwd.Text & "'"

If the above query returns any Records, then you allow the user to login..

You need an ADO Connection object and a Recordset object .
First open the Connection to the Oracle database.
and open a Recordset with this Query:
"Select * From Login_Info_Table Where UserName = '" & txtUser.Text & "'" And Pwd = "'" & txtPwd.Text & "'"

If the above query returns any Records, then you allow the user to login..

Regards
Veena

h'lo veena

i followed the instruction given by u
bt again i think..m wrong somewhere as i hv include few codes by myself
here is the code