[SOLVED] Database Connection Error Message

Monie · #1 Oct 29th, 2007, 05:15

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 · #2 Oct 29th, 2007, 15:09

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 · #3 Oct 30th, 2007, 01:18

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

Monie · #4 Nov 1st, 2007, 07:33

Any one with ASP geek might help?

Eran · #5 Nov 1st, 2007, 14:46

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 · #6 Nov 2nd, 2007, 03:34

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

Eran · #7 Nov 2nd, 2007, 08:08

no problem :]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] Getting the "Microsoft JET Database Engine error '80040e14'" error.	VegaLA	Classic ASP	3	Jan 26th, 2008 00:12
[SOLVED] Easiest way to open database connection!	Monie	Databases	4	Nov 1st, 2007 07:35
Keep getting error message Microsoft VBScript runtime error '800a01a8'	cpando1974	Classic ASP	2	Aug 7th, 2007 12:00
Database connection	fogofogo	Classic ASP	7	Dec 5th, 2005 14:25
Database Connection Strings	Smokie	Classic ASP	0	Aug 7th, 2003 09:51

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
[SOLVED] Database Connection Error Message