Authenticate to Database

[Guest_imported]

Quite new and I have a question, please..

I have a VB6 form/app where I want the user to log in. I have a ODBC connection to MYSql database with usernames and passwords. How do I authenticate their "username" and "password" against the database? I have 2 textboxes and submit button on the form.

 

[aberry]

The way I have found best is simply to take the values from the text boxes and build it into your connection string that connects to the MySQL database.

Connection string then looks something like this:-

db.Open "Driver={mysql}; Server=name;Port=3306;Option=131072;Stmt=;Database=dbname;Uid=" & txtUser.Text & ";Pwd=" & txtPW.text & ";"

Let me know how u get on.

 

[Guest_imported]

Thanks, I will try it that way, bit difficult when you are more used to web and MYSql connectivity than VB.