I am pretty familiar with SQL commands so I think I can figure this out once I get the basics but the basics are killing me and I was not able to find the information elsewhere in the forum.

I am a novice VB6 programmer and need to check an online customer database.


I need information on:
1. What Component do I need to add to my project?
2. Is there anything special I need to do with the component or references to make it work correctly?

Here is what I want to do (pseudo code):
1. set db connection
2. connect to db, tablename
3. "Select * from tablename where user=" & strUser
4. Get other variables placed from recordset (user, password, active (y/n)) into local variables and close connection to DB
5. If password=strPass AND active="Y" then
---->Do Code
-->Else
---->Do Code
-->End If


I have looked through the tutorial and a few other things but still seem to be lost. I *should* be able to figure out the remaining code once I can get a connection set up and working.

I have verified with my host that they allow remote connections and it is set up on my domain.