Post reply

sp_makewebtask error: could not find stored procedure...

  • August 17, 2005 at 1:23 pm

    #94596

    My code is as follows:

    EXECUTE sp_makewebtask @outputfile = 'd:\harvestwise\hwsystem\pickup\PMDRpt.html', @query = 'EXECUTE spMoveSelect @Action=3, @ID=0, @Var1=19', @templatefile = 'd:\harvestwise\hwsystem\pickup\PMDRpt.tpl'

    I get the following errors:

    Server: Msg 2812, Level 11, State 1, Line 0

    Could not find stored procedure 'spMoveSelect'.

    Server: Msg 16805, Level 11, State 1, Procedure sp_makewebtask, Line 125

    SQL Web Assistant: Could not execute the SQL statement.

    The stored procedure is part of a database called "YMCA".  Is there some way to reference the location in the exec command. Or perhaps that is not really the problem.

    Suggestions would be appreciated!

    -Marta

  • August 17, 2005 at 1:25 pm

    #582866

    Try:

    EXECUTE sp_makewebtask @outputfile = 'd:\harvestwise\hwsystem\pickup\PMDRpt.html', @query = 'EXECUTE YMCA.dbo.spMoveSelect @Action=3, @ID=0, @Var1=19', @templatefile = 'd:\harvestwise\hwsystem\pickup\PMDRpt.tpl'

    Cool name for a DB

     


    * Noel

  • August 17, 2005 at 1:46 pm

    #582868

    Thanks!  That got me over the first hump.  The next error is:

    Server: Msg 16822, Level 11, State 1, Procedure sp_makewebtask, Line 125

    SQL Web Assistant: Could not open the template file.

    This is the first time I've used this. 

    thanks in advance!

    -Marta

  • August 17, 2005 at 1:53 pm

    #582869

    Does your SQL Account have read/write rights to that d:\ drive?  I use an *.htm file as a template.  I'm not sure it it has a hardtime with the extension you are using or not.

    I have mine setup to use UNC paths over to my web server.  Would this be possible for you?

     



    Michelle

  • August 18, 2005 at 4:59 pm

    #583368

    sp_makewebtask takes the path relative to the box that SQL is installed on. i.e. it'll be looking for a d: drive on that box, not on your PC.

Viewing 5 posts - 1 through 4 (of 4 total)

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