SQL Server Errors, Cold Fusion and ODBC Errors

[abeckwith]

I have a stored procedure that does a simple insert into a table. The procedure is called from Cold Fusion and even though I am trapping errors in the procedure, ODBC displays its own error message immediately and Cold Fusion never receives the error message that I am returning from SQL Server.

How can I stop ODBC from displaying its own error message? Can I stop SQL Server from sending the error message to ODBC or can I trap the ODBC error message in Cold Fusion?

Thanks
Angela

 

[pigsie]

You can trap the error using cftry and cfcatch. You could then handle the error gracefully and do what ever you want such as send you an email!

HTH

Kola