>>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...

I don't think so. All of the SQL statements are executed through Stored Procedures the same way. Only the one mention is failing.

here is the VBscript code

set conn = createobject("adodb.Connection")
set rs = createobject("adodb.Recordset")
conn.Open db_ConnStr

cData	= "exec sel_comment '" & cPage & "','" & cBase & "',''"

' exec sel_connect 'Default','favorite--Default-',''

set rs = conn.execute( cData )

Perhaps there is a better way to execute the SP.