Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 SQL server and AS/400 connection

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-09-07 : 07:09:01
vicky writes "Hi,

Do we have a process on AS/400, through which we can access data from the SQL server. We have the setup ready alongwith the DTS connection... We need to ask AS/400 to receive data from SQL server.... plz reply at the earliest

Thanks in advance,
Vicky"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-09-07 : 07:11:56
My recent and limited experience with AS/400 data will say no, it probably will not work this way. However, you can set up your DTS package to push data from SQL Server to AS/400, and put it on a schedule. If you need to coordinate the transfer with some AS/400 action then you'll have to provide more details on your scenario.
Go to Top of Page

lizak
Starting Member

12 Posts

Posted - 2005-09-08 : 09:27:18
There are a number of ways of interacting with the AS400 from outside. I'm not clear on what you are trying to do so it's pretty hard to give any more advice.
Go to Top of Page
   

- Advertisement -