Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADODB calling stored procedure
Message
From
09/03/2005 09:04:55
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00993744
Message ID:
00993972
Views:
13
I thought you were saying the way I was creating my Connection, Command and RecordSet objects were causing my problems. I can produce this same problem in VB.NET, VB and Visual Foxpro 9 using ADODB version 2.8. Kurt's response to my problem seemed to fix my problem.

THE "SET NOCOUNT ON" seemed to allow the rest of my Stored Procedure to fire after my Update command, where if did not include it, it would stop at that point.

Thanks for you help with this matter.
Previous
Reply
Map
View

Click here to load this message in the networking platform