SQL Server Errors 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

 

[philhege]

Angela,

How does the error message begin? SQL or ODBC wouldn't write a response back to the browser; it has to be IIS or ColdFusion.

What is the error?