[dba-Tech] FTP

[Rocky Smolin]

Can WINSCP be used inside of an Access program?

On Thu, May 4, 2023 at 2:08 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Ah, PureFTPd. A search on
>  Pure-FTPd   "I won't open a connection to I won't open a connection to"
> FTP.exe
> tgives a number of hits which all say roughly the same thing.
>
> Here's one such:
>
> The Windows FTP command-line client (ftp.exe) does not support the passive
> mode, on any version of Windows. It makes it pretty useless nowadays due
> to
> ubiquitous firewalls and NATs.
> Using the quote pasv won't help. It switches only the server to the
> passive mode,
> but not the client.
>
> Use any thirdparty Windows FTP command-line client instead. Most other
> support
> the passive mode.
> For example WinSCP defaults to the passive mode and there's a guide
> available for
> converting Windows FTP script to WinSCP script. If you are starting from
> the
> scratch, see the guide to automating file transfers to FTP using WinSCP.
> Also,
> WinSCP GUI can generate a script template for you.
>
>
>
> On 4 May 2023 at 9:17, Rocky Smolin wrote:
>
> > I'm still struggling with this FTP problem. To review - user want to
> > have a one button program to FTP a report (PDF) up to his server.
> >
> > I'm using FTP.EXE to test the commands. Here's the results:
> >
> > ftp> open server1.charltonweeks.com
> > Connected to server1.charltonweeks.com.
> > 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
> > 220-You are user number 1 of 100 allowed.
> > 220-Local time is now 16:05. Server port: 21.
> > 220-This is a private system - No anonymous login
> > 220-IPv6 connections are also welcome on this server.
> > 220 You will be disconnected after 30 minutes of inactivity.
> > 504 Unknown command
> > User (server1.charltonweeks.com:(none)): report at aveviction.com
> > 331 User report at aveviction.com OK. Password required
> > Password:
> > 230-OK. Current restricted directory is /
> > 230 21 Kbytes used (0%) - authorized: 2048000 Kb
> > ftp> lcd C:\Clients\Charlton
> > Local directory now C:\Clients\Charlton.
> > ftp> binary
> > 200 TYPE is now 8-bit binary
> > ftp> put "This is a test.docx"
> > 500 I won't open a connection to 100.73.58.84 (only to 136.22.14.68)
> > 425 No data connection
> >
> > The file "This is a Test.docx" shows up in the target directory on the
> > server (I'm using FileZilla to check this) but no data is transferred.
> >
> > The site guy (who is in Pakistan) said:
> >
> > ipconfig/release
> > ipconfig/renew
> > exit
> >
> > But this did not help.
> >
> > Additional datum: when I have my VPN ON (Google 1 VPN) I can connect.
> > When it is OFF the OPEN command in FTP.EXE times out.
> >
> > Any ideas?
> >
> > MTIA
> >
> > Rocky
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>