partial results when stored proc exec from odbc

Thread View: alt.comp.databases

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Eric Reaburn Wed, 04 Jul 2001 01:50

#119

Author: Eric Reaburn
Date: Wed, 04 Jul 2001 01:50

30 lines
2641 bytes

I was wondering if anyone has had trouble executing a stored procedure from ODBC.

I have a stored procedure in SQL Server 2000 that produces complete and correct results when executed from Query Analyzer. However, when it is executed from within my program via ODBC, it appears to stop (without indicating any errors) after producing partial results. 

In both cases it is passed the same parameters (even going as far as hard-coding the values within the stored proc!) and working on the same data. The partial result may be 0, 1, 3, 6, 7 etc. rows instead of the 153 I'm expecting.

Execution has been tested through Borland C++ Builder 5 and ODBC, Delphi 5 and ODBC, Delphi 5 and BDE. Interesting point is that it works fine when exec via BDE.

The logic of the proc is: open a cursor, test a condition for each row retrieved, if the condition passes do a positioned update on the current row.

Using RAISERROR() as a trace, it shows that the proc manages to stop without executing any statements after the cursor loop (when run from ODBC).

Is there some ODBC configuration or connection attribute that needs changing?

Please help, I've been banging my head on this for two days and it's starting to hurt!

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads