Q

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 first 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.

0 comments

Oldest 

Forgot Password?

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

Your password has been sent to:

SearchEnterpriseLinux

SearchDataCenter

Close