Ask the Expert

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/ 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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

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: