Post reply

SQL Server Errors and ODBC Errors

  • March 21, 2002 at 8:22 am

    #157693

    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

    Angela Beckwith


    Angela Beckwith

  • March 21, 2002 at 10:44 am

    #425845

    I think you need to trap it in CF. That's how it's done in VB anyway.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • April 1, 2002 at 1:34 am

    #426332

    It goes pretty much like this:

    <cftry>

    do your query here

    <cfcatch type="database">

    give them the message here

    </cfcatch>

    </cftry>

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply