EXEC in TSQL stored proc causes ERROR

[don schilling]

If I fill my datagrid using a stored procedure that includes the tsql
command "EXEC", the grids reader gives error "Could not find stored
procedure".

Im filling a datagrid by using a command object to a stored procedure:
datagrid.DataSource = objCmd.ExecuteReader(); datagrid.DataBind();
Everything works fine, unless, in the stored proc, the command EXEC
'some sql string' is used. Then, the reader gives the "Could not find
stored procedure ALL OF MY SQL STRING HERE". Like the reader is trying
to find a procedure with a name matching the contents of my sql string
rather than just letting the proc exec the string and return a rs. I
must use a stored proc, and sometimes the proc must use the "EXEC"
command. This used to work fine in ADO. Any ideas?

TIA
Don