Search found 5 matches

by sidler
Fri Oct 28, 2005 9:28 am
Forum: Client - Issues
Topic: Command line mode hangs
Replies: 9
Views: 4599

Hi Chris, I have tried the new corecmd.exe utility. It works as expected in command line mode but still does not work from within TSQL procedures. We see the same problem as before. The procedure hangs forever. I need to kill the coreftp process to de-block the TSQL procedure. In the mean time I als...
by sidler
Fri Oct 07, 2005 11:01 am
Forum: Client - Issues
Topic: Command line mode hangs
Replies: 9
Views: 4599

Why cmd.exe is created? I am not an expert but I guess a shell is needed to execute a command line tool. Anyway, the TSQL procedure xp_cmdshell works this way. I am not aware of any other ways to execute external tool from within TSQL. I have tried the -hide option. This doesn't seem to make a diffe...
by sidler
Wed Oct 05, 2005 10:58 am
Forum: Client - Issues
Topic: Command line mode hangs
Replies: 9
Views: 4599

Hi, thanks for the quick reaction. I tried the new build with the -noicon option but unfortunately the problem remains. This is the current command line I use from within TSQL procedures: C:\PROGRA~1\CoreFTP\coreftp.exe -noicon -O -s -site www_msite_com -u D:\FTP-Server\upload_mysite_web\test_upload...
by sidler
Thu Sep 29, 2005 10:49 am
Forum: Client - Issues
Topic: Command line mode hangs
Replies: 9
Views: 4599

CP, The call is a blocking call i.e. the TSQL procedure hangs until that command line task is completed. The default working directory of the TSQL procedure is C:\WINNT\system32\ on our machine. My guess is that a truly silent mode would solve the problem. We use the command line mode successfully w...
by sidler
Wed Sep 28, 2005 11:32 am
Forum: Client - Issues
Topic: Command line mode hangs
Replies: 9
Views: 4599

Command line mode hangs

Hi all, I am trying to use Core FTP in command line mode to upload files produced by MS SQL Server to a web site. TSQL, the scripting language of MS SQL Server, allows me to execute shell commands. When I try to do this with Core FTP, it hangs forever. I need to kill the Core FTP Process in order to...