dbTalk Databases Forums  

Sybase and "The sql statement does not contain any parameters"

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Sybase and "The sql statement does not contain any parameters" in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andy C
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.