I am trying to create an application that uses the SQL users and password logins and validate them in VB so that I can enable and disable various commands/buttons and also give out a message box if the username or password entered by the user is invalid. Is there a way I can authenticate the username and password in the application without using a stored procedure. I hope this request is not confusing.
This is what I have so far:

cn.Open "PROVIDER=MSDASQL;dsn=QCManager;uid=" & txtuName.Text & ";pwd=" & txtPword.Text & ";database=QCManager;"