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.

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.

Please create a username to comment.