[AccessD] FTP to server

[Rocky Smolin]

Stuart:

the ftpcmdss file is as follows:

open server1.charltonweeks.com
report at aveviction.com
er)]-ldovzIi
cd /
lcd C:\Clients\Charlton
binary
put "This is a test.docx"
bye

Filezilla connects with those credentials. And I can drag and drop the docx
file. to the server. But using the program I wrote using your (modified)
code the program connects and creates the file but the file has zero length.

So I did what you suggested - use FTP.EXE and enter the commands one by one
as shown in the ftpcmd file. Here's what happens:

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 18:07. 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 0 Kbytes used (0%) - authorized: 2048000 Kb
ftp> quote pasv
227 Entering Passive Mode (184,94,215,208,236,38)
ftp> cd /
250 OK. Current directory is /
ftp> lcd C:\Clients\Charlton
Local directory now C:\Clients\Charlton.
ftp> put "This is a test.docx"
500 I won't open a connection to 100.64.156.235 (only to 136.22.14.11)
425 No data connection
ftp>

Thanks and HTH,

r

On Wed, May 3, 2023 at 2:30 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Can you send me a copy of the ftpcmds files ?
>
> (I can't connect to either of those IP addresses with FTP.exe)
>
>
> On 3 May 2023 at 8:27, Rocky Smolin wrote:
>
> > Stuart (or anybody)
> >
> > So I got the code working that you sent - connect to the server, ftps
> > the file to the server, but the file ends up with zero bytes.
> >
> > When I use FTP.exe and put the commands in manually the last command -
> > ftp? put "This is a test.docx" I get the response: 500 I won't open a
> > connection to 100.68.156.242 (only to 136.22.14.36)
> >
> > Any idea what this means and how to get around it?
> >
> > TIA
> >
> > Rocky
> >
> >
> > On Thu, Apr 20, 2023 at 8:01PM Rocky Smolin
> > <rockysmolin2 at gmail.com> wrote:
> >
> > > Thank you.  I took a look at it. I'll try to make sense of it.
> > > Stand by for questions. "o)
> > >
> > > r
> > >
> > > On Thu, Apr 20, 2023 at 2:30PM Stuart McLachlan
> > > <stuart at lexacorp.com.pg> wrote:
> > >
> > >> Sent.
> > >>
> > >> On 20 Apr 2023 at 9:40, Rocky Smolin wrote:
> > >>
> > >> > Yes, in Access. I remember but the client went away to try to do
> > >> > it himself so I stored that demo and now can't retrieve it.
> > >> > Could you send again?
> > >> >
> > >> > Thanks
> > >> >
> > >> > r
> > >> >
> > >> > On Wed, Apr 19, 2023 at 9:43PM Stuart McLachlan
> > >> > <stuart at lexacorp.com.pg> wrote:
> > >> >
> > >> > > In Access or do you just want to upload a file to a server?
> > >> > >
> > >> > > If in Access, we went through this on 31 Mar/ 1 Apr.   I sent
> > >> > > you a sample database that does it on 31 March.
> > >> > >
> > >> > >
> > >> > >
> > >> > >
> > >> > > On 19 Apr 2023 at 20:00, Rocky Smolin wrote:
> > >> > >
> > >> > > > Dear List:
> > >> > > >
> > >> > > > I am looking for some help FTPing a file to a server.  The
> > >> > > > user has given me the Host (target server), User Name,
> > >> > > > Password, and Port.  I can open a file dialog box for him to
> > >> > > > point to the file to be uploaded.
> > >> > > >
> > >> > > > But I can't find what I'm looking for on the web that doesn't
> > >> > > > use and ocx or other 3rd party tool that I don't have anyway.
> > >> > > > Would like to keep it simple if possible.
> > >> > > >
> > >> > > > MTIA
> > >> > > >
> > >> > > > Rocky
> > >> > > > --
> > >> > > > AccessD mailing list
> > >> > > > AccessD at databaseadvisors.com
> > >> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > >> > > > Website: http://www.databaseadvisors.com
> > >> > > >
> > >> > >
> > >> > >
> > >> > > --
> > >> > > AccessD mailing list
> > >> > > AccessD at databaseadvisors.com
> > >> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > >> > > Website: http://www.databaseadvisors.com
> > >> > >
> > >> > --
> > >> > AccessD mailing list
> > >> > AccessD at databaseadvisors.com
> > >> > https://databaseadvisors.com/mailman/listinfo/accessd
> > >> > Website: http://www.databaseadvisors.com
> > >>
> > >>
> > >> --
> > >> AccessD mailing list
> > >> AccessD at databaseadvisors.com
> > >> https://databaseadvisors.com/mailman/listinfo/accessd
> > >> Website: http://www.databaseadvisors.com
> > >>
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>