question

satya0485 avatar image
satya0485 asked

Executing Sybase store procedure in Sql Server using Linked Server

I am trying to Exectue sybase stored procedure using linked server in Sql server 2008 R2 but throws errors: Below are the methods i am using EXECUTE [LinkedServer].[DB].[dbo].[StoredProcedure] 1, 'F', NULL, NULL, NULL, NULL OR declare @Parameter1 NUMERIC(38) declare @Parameter2 NUMERIC(6) declare @Parameter3 VARCHAR(250) EXECUTE [LinkedServer].[DB].[dbo].[StoredProcedure] 1, 'F', NULL, NULL, NULL, NULL, @Parameter1 Output, @Parameter2 Output, @Parameter3 Output OR EXECUTE ('EXECUTE [DB].[dbo].[StoredProcedure] ?,?,?,?,?,? ', 1, 'F', Null , NULL, NULL, NULL ) AT [LinkedServer] **Below is the error :** The attempt by the provider to pass remote stored procedure parameters to remote server '[LinkedServer]' failed. Verify that the number of parameters, the order, and the values passed are correct. I have set the RPC out values to true in Linked server properties. But I am not sure if I am missing any other properties. Could someone please help me Many thanks in advance S
sql-server-2008-r2stored-procedureslinked-server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.