MSACCES to AS400

Tags:
AS/400
Development
RPG
SQL
VB.NET
Visual Basic
I am currently working on a project where I need to take files from a MsACCESS and transfer them to the Iseries possibly replacing them on a daily basis. I have been able to export them to the ISERIES manually, via the export on the file menu. I have not been able to find an export sample with a good explanation on the TransferDatabase command for the odbc driver. Any help would be appreciated. Is it possible to do a replace of an As400 file during this operation, seems on the manual export I can only create. Thanks Ken

Answer Wiki

Thanks. We'll let you know when a new response is added.

This brings back memories from back in 1998 when I wanted to link an as400 database to an Access 97 database project. It worked via ODBC, but was very slow (I was only given a 133Mhz PC back then and the databases were 2+GB in size). I was able to run queries and generate reports (albeit slowly – sometimes locking up the system). I’m sure performing this task nowadays is far simpler and faster. As for reversing this task, I’m not sure how it would work – just thought I’d provide some insight on past experience.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Lpgast
    I have done this many times in the past. What I recommend, depending on the Access version you are using, is to switch to ADO, it performs much better than ODBC. But the technique I use works either way. Rather than using transferdatabase, Create a recordset object and loop throught it, for each record retreived create an 'INSRT INTO' statement and the use a command object for the AS400 (Database object under ODBC), and execute the SQL String. This performs rather well, although large recordsets will take some time. This allows you add in validations and filters in one place and the AS400 only has to issur the updates. I haven't done this in some time, but I can throw together an example if you need it.
    0 pointsBadges:
    report
  • Tmalik
    Look into Client Access remote command services. Here is what you basically will be doing. 1) Create a data transfer session to the AS/400 2) Save it on your pc 3) Create a .bat file invoking that transfer session 4) Save that on your pc 5) call the .bat file from the AS/400. You must have the client access remote command service running on the pc. Look at the windows services and there is a client access remote command service that does not strart automatically, you must start that automatically to accept commands from the As/400. YOu can then start the command to executer the .Bat file from the AS/400 job schduler on a nightly basis. Thanks Malik
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following