ADO Connection String Question

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

i dont know jack haha
excuse the pun
about setting up members areas with usernames and passwords could you help me out
im pretty much in the same boat really
i have an SQL 7 database and trying to create the same thing as you are!!!with heaps of problems!!!
thanks