Catch SQL Login Failure

[Patrick Steele [MVP]]

In article <3f12fb6f$1@news.012.net.il>, [email]kamara1@yahoo.com[/email] says...

> Hi,
>
> How can i "catch" the SQL login error message and display one of my own?

You should be able to catch the SQLException and then examine the
"Number" property.

--
Patrick Steele
Microsoft .NET MVP
[url]http://weblogs.asp.net/psteele[/url]

[Tamir Kamara]

i don't understand.
can you give an example?


"Patrick Steele [MVP]" <patrick@mvps.org> wrote in message
news:MPG.197ccf0b1aeb26689897a4@msnews.microsoft.c om...

> In article <3f12fb6f$1@news.012.net.il>, [email]kamara1@yahoo.com[/email] says...

> > Hi,
> >
> > How can i "catch" the SQL login error message and display one of my own?

>
> You should be able to catch the SQLException and then examine the
> "Number" property.
>
> --
> Patrick Steele
> Microsoft .NET MVP
> [url]http://weblogs.asp.net/psteele[/url]

[Patrick Steele [MVP]]

In article <3f1376f3$1@news.012.net.il>, [email]kamara1@yahoo.com[/email] says...

> i don't understand.
> can you give an example?

Dim sqlConn As SqlConnection = New SqlConnection("your_conn_string")

Try
sqlConn.Open()
Catch ex As SqlException
If ex.Number = 1234 Then ' replace 1234 with proper sql code
...
End If
End Try

--
Patrick Steele
Microsoft .NET MVP
[url]http://weblogs.asp.net/psteele[/url]