schedule data driven subscription using stored procedure

I'm trying to set up a data driven subscription using stored
procedure, on step 3 box I typed in my stored procudure
name:proc_Reports_test and clicked on validate button, I got following
error message:
The dataset cannot be generated. An error occurred while connecting to
a data source, or the query is not valid for the data source.
(rsCannotPrepareQuery)
Line 1: Incorrect syntax near 'proc_Reports_test'.
Has anyone else had this issue?
Thanks advance for any help.Try 'exec proc_Reports_test' instead
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Danni Liao" <danniliao@.yahoo.com> wrote in message
news:9d716b4a.0410210752.5a1fd0ba@.posting.google.com...
> I'm trying to set up a data driven subscription using stored
> procedure, on step 3 box I typed in my stored procudure
> name:proc_Reports_test and clicked on validate button, I got following
> error message:
> The dataset cannot be generated. An error occurred while connecting to
> a data source, or the query is not valid for the data source.
> (rsCannotPrepareQuery)
> Line 1: Incorrect syntax near 'proc_Reports_test'.
> Has anyone else had this issue?
> Thanks advance for any help.