Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling a Stored Procedure from VFP9
Message
 
 
To
07/09/2012 12:18:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MS SQL Server
Miscellaneous
Thread ID:
01552550
Message ID:
01552577
Views:
34
>>>No, I didn't see a call to my SP
>>>Yes, I used the default template
>>
>>Do you have batch completed and procedure completed events? These are the only two you need. If you don't see calls to your SP after you run the trace, then your SP is not called.
>
>Then why is it saying that it can't find the SP on the 2nd time through? I do see connection_resets being called in the trace and the only SP I see being called is some generic getbatchid proc.

Post a screen shot of your profiler trace.
Also, try placing a break point on the SQLEXEC line and see if anything is shown in the trace after you click on it.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform