Post reply

passing parameters to stored procedure through OPENQUERY

  • August 15, 2014 at 9:59 am

    #1738441

    sgmunson (8/15/2014)

    Are you sure that the @date parameter should have a character value of OBJECTIDLIST ? That's not a terribly well-named parameter if it should. I know that the code attempts to see if I have a linked server when I try to execute it, and I only fail on the fact that I don't have that linked server, nor that stored procedure. Please verify the value for that parameter.

    The parameters on the stored procedure are:

    @table_name varchar(100),

    @date varchar(100),

    @reduce varchar(10),

    @oid nvarchar(4000)

  • August 15, 2014 at 10:03 am

    #1738446

    Alex R (8/15/2014)

    sgmunson (8/15/2014)

    Are you sure that the @date parameter should have a character value of OBJECTIDLIST ? That's not a terribly well-named parameter if it should. I know that the code attempts to see if I have a linked server when I try to execute it, and I only fail on the fact that I don't have that linked server, nor that stored procedure. Please verify the value for that parameter.

    The parameters on the stored procedure are:

    @table_name varchar(100),

    @date varchar(100),

    @reduce varchar(10),

    @oid nvarchar(4000)

    That says nothing about what the value needs to be. Without a linked server to work with, there's nothing further I can do. What does the stored procedure do with it?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply