Tweet
Help, I am having trouble using FTP commands to upload file from PC to AS400. We have contracted consultants to write application in VB6.0 to collect data from multiple Access databases, write those records to one table that we try to send up. Apparently VB6.0 does not have MS-Dos support in it and when we try to run the windows based script the application hangs up. We have tested manually using a ms-dos window with the FTP commands and it works fine. Any suggestions?
-
-
FTP Problems
What is your situation? Does the PC have ODBC access to your AS/400? If so, you can have VB6 write to a data base file on the AS/400. Just have it read the Access files and write to the AS/400 file. You can also read and write to AS/400 files from Access. In that case you don't need VB. You can use Access to do a file copy. If the PC does not have ODBC access, you must export a file from Access or have VB6 write a flat file. You then use FTP to send the flat file to the AS/400. Finally you need a program on the AS/400 to read in the flat file and write it to the data base. -
FTP Problems
Situation is I have 16 PC with individual Access databases. Visual basic application takes the records from these 16 db's and writes them to a flat file that we are trying to get uploaded to the AS/400. The AS/400 has the file and trigger programs complete to handle the data uploaded from the PC's. The problem is getting the ftp commands working with a script file.Comment
-
FTP Problems
You would make a batch file for the FTP, then use a shell command to execute the batch file from your VB6 or Access program. In DOS, use "FTP -HELP" to display the options for the FTP command. You will see the -s: option for input file. The FTP commands can not be in the batch file, they must be in the input file specified in the -s:.Comment
Comment