>EXECUTE, short form of it, EXEC calls stored procedure to
>run. As I know CALL is specific some dialects of SQL
>Watcom-SQL). Actually you do not need specify EXEC at
>if you are using Command object to execute it. What you
>need to do is to specify type of command as
>>Thank you very much Val,
>>Can you explain me what is teh difference between Call
>>Thank you so much
>>>Try to use EXEC or EXECUTE instead of CALL.
>>>strsql = "exec sp_name 12 , 'Thota SRidhar (IL) '".
>>>It should work,
>>>>Can any one help me , how can i get rid of this error.
>>>>In my VB DLL I am calling a sybase stored procedure
>>>>has two parameters. like this
>>>>strsql = "call sp_name 12 , 'Thota SRidhar (IL) '".
>>>>(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
>>>>If I remove the paranthesis , it is excuting
>>>>Is it the problem of ADO or sybase. I cannot remove
>>>>braket from the parameter. Please help me in this
>>>>I am using ADO 2.6 and sybase 11.0