Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Errors when called from ADO
Message
De
25/11/2016 07:53:30
 
 
À
25/11/2016 07:31:30
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01643938
Message ID:
01643942
Vues:
33
>Good day all,
>
>Resently I have been getting a random error when I execute a T-SQL EXEC statement via ADO in a VBscript code.
>
>
>
>exec sel_comment 'Default','favorite--Default-',''
>
>
>error is
>
>[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '20'.
>
>The statement executes with an error when cur/paste in SSMS, but occurs when called from SQLconnection.execute in the code.
>
>I have not been able to find a solution on the web, Sometimes, the statement executes correctly, but most of the time it does not.
>
>Can someone suggest a idea to help me resolve the source of the error.

Is your statement being encoded in some way / circumstances? "20" is hexa for space, so...
----------------------------------
António Tavares Lopes
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform