using Internet transfer control with a secure FTP host

[PanamaTiger]

I have had difficulty finding what the problem is. I am a very experienced
MS Access & Visual Basic programmer, but I have not been able to find
adequate documentation for this control and the error message is extremely
vague. The error I get is:

35754 Method 'Execute' of object 'IInet' failed

I have simplified the code and it is listed below:

Dim strSite As String
Dim strFile As String
strSite = "ftp.arinc.com"
strFile = "WGAErrLog.txt"
objFTP.Protocol = icFTP
objFTP.UserName = "amns_user1"
objFTP.Password = "amns_tiger"
objFTP.RemotePort = 22
objFTP.URL = strSite
objFTP.Execute strSite, "Get " & strFile & " C:\Temp\WGAErrLog.txt"

Any clue?
TIA,
PT

 

[Tom van Stiphout]

On Thu, 19 Jun 2008 13:15:07 -0700, PanamaTiger

I'm not sure what the problem is. Are you sure the Port number is
correct? 22 seems an unusual number for FTP. 21 is much more common.

If with "secure ftp" you mean "I need to specify a u/pw", you can try
for the URL:
ftp://myUsername:myPassword@myFtpUrl

-Tom.

 

[PanamaTiger]

using the "ftp://myUsername:myPassword@myFtpUrl" format for the URL but no joy.

FYI, a lot of administrators will use a non-standard port address to make
the FTP server 'less visible' and when I use a standard FTP tool such as
FileZilla I have to change the port to 22.

I think I will set up an FTP server at home to see if it is not something
server-side.

Thanks & please post any ideas as I am scratching my head over this one
since the error message is so vague.

35752 Method 'URL' of object 'IInet' failed