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-08-24 : 23:16:04
|
| Jean-Francois writes "Hi !I have a SP ( MsSql 7.0 ) called from a VB ( Vb 6.0, on Windows NT ) program. Sometimes, it looks like if it stops for no reason. The VB code doesn't raise any error, and the OUTPUT parameter of the SP isn't change since the last time it has been executed.A friend told me to delete all the SELECT clause ( those who doesn't affect a value to a variable ), because he already had this kind of trouble. But it didn't change anything...Could you help me ?Thank you." |
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2002-08-25 : 01:03:55
|
| How long does the SP take to run? Are you maybe running into a timeout issue?Try writing a test harness for the SP in query analyzer, and see if it works every time. If so, try setting a breakpoint in your VB code after the .execute or .open that calls the stored procedure. Carefully examine all of the SQL variables, like ADODB.connection.errors.count. Also make sure you don't have an "on error resume next" floating around somewhere that may be causing an error to be ignored.Cheers-b |
 |
|
|
|
|
|
My Stored Procedure seems to stop for no reason