Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling Procedures from Cold Fusion and ODBC Errors

Status
Not open for further replies.
abeckwith

abeckwith

MIS
Feb 14, 2002
8
US

I am using SQL Server 2000 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.

Help Please
Angela
Angela.Beckwith@ssigroup.com
 
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
396
bharons
bharons
peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
300
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
388
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
173
grnzbra
grnzbra
ms901Boss
  • Locked
  • Question
Join two select statements and collecting data from both
Replies
13
Views
185
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top