x

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

more ▼

asked Jan 14, 2014 at 03:42 PM in Default

avatar image

satya0485
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x775
x472
x140

asked: Jan 14, 2014 at 03:42 PM

Seen: 1401 times

Last Updated: Jan 14, 2014 at 03:42 PM

Copyright 2017 Redgate Software. Privacy Policy