I'm passing a user entered username & password that is supposed to correspond to a User account on a SQL Server database as opposed to checking a "Users" table.

If the user entered an invalid password...I would like a custom error page to display. My question is what do I look for to trap if my connection string has an invalid password in it? Unless I'm reading it wrong, (definately possible), the OPEN method of the Connect object doesn't return any values.

Thanks in advance,
Jack