I need to perform Secure FTP with Foxpro

Posted on 2011-05-11
Last Modified: 2012-05-11
Currently, I use microsoft's FTP.EXE supplied in the operating system to perform file transfers from mainframe to workstations then import into foxpro databases.  My users just enter their password and I create a script file used by FTP.EXE.  Apparently corporate head office does not approve of this since it is unsecure.

I am looking for a secure FTP application that I can run from Foxpro with a script file so my users still do not need to know where the files are coming from or going to.

Any ideas?

Question by:rickbull
    LVL 12

    Accepted Solution

    Have you done a Google search for:
                   sftp vfp
                   sftp activex

    Both will provide you with a number of tools to utilize to get SFTP working.

    Personally I have used the various Chilkat tools to address a number of 'challenges' - SSH/SFTP among them.

    Good Luck

    LVL 41

    Expert Comment

    No FTP storage is secure because the communication is not ecrypted but it seems this is not the main concern of your corporate head office...

    So, you may use Custom FTP class designed especially for this purpose:

    LVL 41

    Expert Comment

    Of course, sftp is better from the security point of view.
    LVL 16

    Expert Comment

    Robo-FTP is a scriptable and supports secure transfers with SFTP, FTPS, and HTTPS.  It has a full scripting language with over 100 commands and is supported by real live people.  From FoxPro you could either launch it and specify the script and files to send as command line parameters or you could use the COM / ActiveX interface to control Robo-FTP directly from within your application.

    Author Closing Comment

    Thank you, I found the Chilkat and also Eldos SecureBlackBox.  I will try them out.

    Thanks pcelba as well.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
    In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
    The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
    The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now