Quote:>-----Original Message-----
>Hi,
>EXECUTE, short form of it, EXEC calls stored procedure to
>run. As I know CALL is specific some dialects of SQL
(Like
>Watcom-SQL). Actually you do not need specify EXEC at
all,
>if you are using Command object to execute it. What you
>need to do is to specify type of command as
adCmdStoredproc
>Val
>>-----Original Message-----
>>Thank you very much Val,
>>Can you explain me what is teh difference between Call
>and
>>EXEC statments.
>>Thank you so much
>>Thota
>>>-----Original Message-----
>>>Hi,
>>>Try to use EXEC or EXECUTE instead of CALL.
>>>strsql = "exec sp_name 12 , 'Thota SRidhar (IL) '".
>>>It should work,
>>>Val
>>>>-----Original Message-----
>>>>HI,
>>>>Can any one help me , how can i get rid of this error.
>>>>In my VB DLL I am calling a sybase stored procedure
>>which
>>>>has two parameters. like this
>>>>strsql = "call sp_name 12 , 'Thota SRidhar (IL) '".
>>>>cnn.execute(strsql)
>>>>(May be syntax is not correct here)
>>>>If I pass paranthesis in a parameter it is failing and
>>>>giving the error message as unterminated string
>>constant.
>>>>If I remove the paranthesis , it is excuting
perfectly.
>>>>Is it the problem of ADO or sybase. I cannot remove
>the
>>>>braket from the parameter. Please help me in this
>>regard.
>>>>I am using ADO 2.6 and sybase 11.0
>>>>Thanks
>>>>Thota
>>>>.
>>>.
>>.
>.
by