Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server pass thru transaction problem
Message
From
05/12/2002 11:54:42
 
 
To
05/12/2002 11:22:30
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00729697
Message ID:
00729933
Views:
21
This message has been marked as the solution to the initial question of the thread.
I added the following lines at the beginning of my SQL commands and it resolved all my problems.
SET NOCOUNT ON
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER OFF
I suspect the NOCOUNT is the important line. I discovered this while refactoring my solution. I had moved the transaction handling to SQL and was trying to send the error status back as a result set. I wasn't getting the result set. I had seen this behavior before and it rang my bell. Thanks.
Previous
Reply
Map
View

Click here to load this message in the networking platform