Post reply

Help

  • February 9, 2007 at 12:30 pm

    #116121

    BEGIN

     DECLARE @cmdstr VARCHAR(8000)

     

     ''http://cincy.rapmls.com/scripts/mgrqispi.dll? APPNAME=Cincynky&PRGNAME=MLSBulkLoadPictures&ARGUMENTS=-ACIN, -N99999, -A\\\\App02\\FTProot\\cinci\\pictureupload\\,-AY'''

     SET @cmdstr = 'HTTP /s "http://cincy.rapmls.com/scripts/mgrqispi.dll? APPNAME=Cincynky&PRGNAME=MLSBulkLoadPictures&ARGUMENTS=-ACIN, -N99999, -AK:\\cinci\\pictureupload\\,-AY"' -- Modified 7/13/06 CO

      EXEC master.dbo.xp_cmdshell @cmdstr

    END

     

    when i am running the above command in query analyser i am getting the following error

    'HTTP' is not recognized as an internal or external command,

    operable program or batch file.

    NULL

     

    Thanks

    Khan

  • February 9, 2007 at 12:58 pm

    #688954

    What happens if you run the same command from a DOS prompt?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • February 9, 2007 at 1:29 pm

    #688959

    getting the same error.

  • February 9, 2007 at 2:38 pm

    #688973

    did you create a program called HTTP.exe?

    that is the error you are getting.

    maybe it does exist, but it's not in the path of the server when it's run?

    maybe something like C:\Program Files\HTTPInstallationFolder\HTTP.exe /s "http://cincy.rapmls.com/scripts/mgrqispi.dll?APPNAME=Cincynky&PRGNAME=MLSBulkLoadPictures&ARGUMENTS=-ACIN, -N99999, -AK:\\cinci\\pictureupload\\,-AY"

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 9, 2007 at 3:58 pm

    #688982

    Yes, Lowell is correct.  There are only a few options here.  Either the program HTTP.exe does not exist, or it cannot be found in your PATH.  If you do have the program, either add it's directory to the PATH environment variable, or fully qualify the path as in Lowell's example.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • February 12, 2007 at 2:45 pm

    #689309

    After i put the http.exe in the path it worked.

    Thanks

    khan

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

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