Problem solve Get help with specific problems with your technologies, process and projects.

Transfer files

We are looking to be able to transfer files from a server running Microsoft SQL Server 7.0 to our AS/400, using programs launched from the AS/400...is this possible, are there any products you know of to facilitate this?

I'm assuming you need to be able to write arow to ms SQL after it was written to AS/400 database.

Several options:

1. Use Java on the AS/400 and write to ms SQL using native jdbc driver.

2. Use a product such as IBM's data joiner that will let you perform drda over different databases.

3. Use a replication product such as symbiator from vision solution.

4. Use program on the pc that will use ODBC to monitor requested files for new rows and then write the new rows to ms SQL.

This was last published in November 2001

Dig Deeper on iSeries Access (Client Access)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.