Help

Question

Post reply

Help

Hammad khan

Mr or Mrs. 500

Points: 552
More actions
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

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

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

John Rowan SSC Guru Points: 56440 More actions · Answer 1

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

Hammad khan Mr or Mrs. 500 Points: 552 More actions · Answer 2

Hammad khan

Mr or Mrs. 500

Points: 552

February 9, 2007 at 1:29 pm

#688959

getting the same error.

Lowell SSC Guru Points: 323518 More actions · Answer 3

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!

John Rowan SSC Guru Points: 56440 More actions · Answer 4

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

Hammad khan Mr or Mrs. 500 Points: 552 More actions · Answer 5

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

Thanks

khan