Passing Parameters through a linked server?

[Adam Smith]

Hello I have a stored proc:

CREATE PROCEDURE dbo.sp_test
@IN int,
@ID int OUTPUT
AS
begin
SET NOCOUNT ON

Set @ID=12345 + @IN
end

GO

I'm executing this through a linked server. The exception returned is:

Could not execute procedure 'sp_test' on remote server
'QAPS2Remote'.\r\n[OLE/DB provider returned message: Parameter type
cannot be determined for at least one variant parameter.]

The literal query being run is:

declare @P1 int
set @P1=NULL
exec QAPS2Remote.HRXMLCollector_prod.dbo.sp_test @IN = 1, @ID = @P1
output
select @P1

How do I declare the parameters using C#? The code I'm using is:

dbCommand.Connection = conn;
dbCommand.CommandType = CommandType.StoredProcedure;

dbCommand.CommandText = "QAPS2Remote.HRXMLCollector_prod.dbo.sp_test";

SqlParameter sqlParameterIn = dbCommand.Parameters.Add("@IN",
SqlDbType.Int);

sqlParameterIn.Direction = ParameterDirection.Input;
sqlParameterIn.Value = 1;
SqlParameter sqlParameterOut =
dbCommand.Parameters.Add("@ID",SqlDbType.Int);
sqlParameterOut.Direction = ParameterDirection.Output;

dbCommand.ExecuteNonQuery();

Thanks in advance.

 

[Sahil Malik]

Are you able to execute this without linked servers in picture?

- Sahil Malik
You can reach me thru my blog http://www.dotnetjunkies.com/weblog/sahilmalik

 

[Adam Smith]

It executes flawlessly without the linked server.