Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server pass thru transaction problem
Message
De
05/12/2002 11:54:42
 
 
À
05/12/2002 11:22:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00729697
Message ID:
00729933
Vues:
22
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform