[SOLVED] Database Connection Error Message

[Monie]

I wanted to do an error massage in my ASP-MySQL page more similar to what I've learned in PHP.

Can this be done in ASP page? Thanks..

PHP: Select all

// 1. Create a database connection
$connection = mysql_connect("localhost", "root", "mypassword");
if (!$connection){
      die("Databse connection failed: " . mysql_error()));
} 

[Phil]

Hi Monie,

Have you tried using something like this

HTML: Select all

<%
If Err.number <> 0 then     'if there is an error 
response.write Err.number     'write out the error number
response.write Err.source     'write out the error source
response.write Err.description     'write out the error description
End If
%> 

I'm not entirely sure it will produce the same kind of output as the php code you've posted.

[Monie]

Yeah I've tried that, but I am looking for something more specific, like PHP does!
Thanks..

[Monie]

Any one with ASP geek might help?

[Eran]

as phil said you can do the error object http://www.w3schools.com/ado/ado_ref_error.asp

but i think that the die statement is more like "on error resume next"
you can look for it in this ADD sample
http://www.w3schools.com/ado/ado_add.asp

you can play with them both to make your own message or a real ADO error jibrish text

[Monie]

Thanks Eran, really helps me with all the question in mind

[Eran]

no problem :]