Catch MS SQL errors using ASP and display custom page...

[skurpyun]

Hey all,

I am using asp to code a page and process a page that inserts data into an MSSQL database. While I have done everything (everything as far as validating form inputs) to prevent the database from throwing errors when using the insert command. Yet, I am still concerned about the database throwing errors (and in some cases giving away tables names and/or database structure in the process). So here's the question: Is it possible to catch errors thrown by a database in ASP/VBscript?
Your help is greatly appreciated.

-sk

 

[palbano]

In javascript you use exception handling with try{}catch{} blocks. I think in VB you use ON ERROR GOTO ????

Where are all the VB folks?

-pete

 

[baddos]

On Error Resume Next
Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.Open "Some Connection String"
objConn.Execute("INSERT INTO bleh (field1) VALUES ('bleh')&quot
If objConn.Error.Count > 0 Then
For Each objError in objConn.Errors Then
'Do something w/ the error
Response.Write objError.Description
Next
Else
Response.Write SQL took okay
End If
objConn.Close
Set objConn = Nothing
On Error Goto 0

 

[skurpyun]

palbano and baddos,

thanks for both your posts. Baddos, you've pretty much hit the jackpot with your post. while i'm still re-doing some code to incorporate it and test it out, logically it seems to be how this is done and i did come across similar code construct in an old VB book i've found. thanks.

-skurpyun