cfexecute, batch file, and a ftp script

[dr_bozak]

I have a batch file which works fine when entered in at the command prompt;
C:/temp/mybat.bat
but when I use cfexecute it fails.

Now this may be more of a case of what I am calling than CF itself.
here is the output:

C:\CFusionMX7\runtime\bin>"C:\Program Files\Ipswitch\WS_FTP Professional\ftpscrpt" -f C:\temp\poolsite.scp Processing Line 1 [CONNECT pacmed -p] Finding Host poolsite... Address lookup of "poolsite" failed. It may be misspelled, or your computer may not be connected to the network or Internet. Also check that your DNS and local name servers are properly configured and responding. Failure in command [CONNECT poolsite-p] Processing Line 2 [ONSUCCESS SHELL C:/temp/remove.bat] Set [ONSUCCESS] action to [SHELL C:/temp/remove.bat] Processing Line 3 [MPUT c:/temp/apptTxfr/*.*] Not Connected Failure in command [MPUT c:/temp/apptTxfr/*.*] C:\CFusionMX7\runtime\bin>ECHO OFF


the very odd thing, is again, when I call this from a command line, it works fine.
are there any wrappers or special ways I need to encapsulate this when using cfexecute?

[Mr_Black]

Looks like account problem. What account CF service is using? Try, at least temporarily, change the account to the one you used interactively. See if it helps.

[BKBK]

I would second Mr Black's suggestion. Here's more

[dr_bozak]

Thank you for the suggestions. The odd thing though, is it looks like it calling the batch file just fine. It's just that for whatever reason, the ftp client isn't getting fed the paramters correctly. Ie

Processing Line 1 [CONNECT poolsite-p] Finding Host poolsite...

passing -p tells the ftp client to use a prefdefined site profile (poolsite), instead of using the hostname poolsite. Basically it is if for whatever reason the ftp program is not reading it''s scp file correctly when invoked from CF.

I'll check out the permissions and report back.

thanks for the suggestion.

[Mr_Black]

I see... This explains why DNS lookup fails. As I understand your FTP script is in that *.scp file? What is you batch file exactly?