Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jlz
Starting Member
4 Posts |
 Posted - 2002-09-18 : 02:15:00
|
| Hi,i'm getting the following error when i try connecting to a ftp server using xp_cmdshell:> ftp: connect :Unknown error numberi've tried some different approaches, but no success. the same command/batch file/ftp script works fine when i use a cmd prompt. Has anyone else had this problem?JLZ |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-09-18 : 05:55:36
|
| Over a year ago, we had this problem. We were running SQL 7. Jobs run perfectly from command prompt, either as commands or as batch file, but fail from SQl schedule. SAD to say, I don't have an answer. We eventually decided to run the jobs from a scheduler outside of SQL- used a windows-based version of the AT command - WinAt I think.... |
 |
|
|
jlz
Starting Member
4 Posts |
Posted - 2002-09-19 : 20:18:25
|
| Turns out it was a proxy problem. I had to change the logon credentials of the MSSQLSERVER service and now it works :) |
|
|
|
|
|
|
xp_cmdshell ftp error