Sybase and "The sql statement does not contain any parameters" -
10-19-2004
, 03:43 AM
I'm trying to execute a stored procedure on a Sybase database from a DTS
Eecute SQL task but I keep getting the message ""The sql statement does not
contain any parameters" when I try to set the parameters. When I click on
"Parse Query" I get "Successfully parsed SQL Statement". I know the
connection is OK because if I use "Build Query" I can browse the Sybase
tables.
My stored proc call is as follows:
EXEC dbo.sybaseStoredProc ?,?,?
I've tried setting the Prepare Method on the data source to "1" but with no
luck - is there some restriction about executing Sybase stored procs from an
ExecuteSQL object or is my syntax wrong?
Thanks,
Andy C |