>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
>
>
>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.
Update:
I discovered that between the Execute call and SQL Server, the white spaces are being converted to "%20". Is there a property in the ADO object to handle this?
Greg Reichert
