Sql server login

[Derek]

Hi,
How do i check to see if the login and password match in an sql server. The database is an sql database.There is no table called database table where the user names and logins are usually stored. So there are no user names and logins.What code would i write?? Please help.
Thanks alot,
PS: We are all connected to the network and we all have logins and passwords

try to trap the error message when trying to connect to SQL server from the VB.
If no error then continue with your logic. Other wise raise the exception and display error message and/or abort the program.

Pl use On Error GoTO errorhandle