Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-25 : 08:57:09
|
| Angela writes "I am using SQL Server 2000 and Windows 2000 Prof. to write a store procedure that inserts a record into a table. There is error handling to return an error to Cold Fusion, but when an error is received, Cold Fusion is popping up with an ODBC error from SQL Server and is never getting to the point where it can check the return code.I have an Oracle Database also and it returns the error correctly to Cold Fusion, but for some reason ODBC is interfering with the SQL Server procedure when it gets the same kind of error.Is there a way to stop SQL Server from sending an error to ODBC automatically? Help PleaseAngela" |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-02-25 : 09:51:18
|
| What is the ODBC error you are getting? This sounds like a connection or login failure that occurs before the stored procedure executes. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-25 : 14:54:16
|
quote:
Is there a way to stop SQL Server from sending an error to ODBC automatically?
Yeah, as Andre suggests, you have to track down what's causing that error and eliminate it. I imagine that Cold Fusion (I've never used it myself though) has error handling routines, and that it doesn't automatically transfer all errors to an error handler unless specifically told to do so...like the Visual Basic "On Error Resume Next" or "On Error Goto..." constructs. |
|
|
|
|
|
|
Calling Procedures from Cold Fusion and ODBC Errors