Can I implement a replication between sql server 2005 and IBM AS400 DB?

Hello,

I want to set up As400 DB as a publisher and the sql server 2005 as a subscriper, so that I can read some data from AS400 DB in sql server 2005 and every evening, I need the replicated data from AS400 to be refreshed.

Can I do it ? If yes, how to do it?

Thanks

You cannot subscribe to an AS400 publication from SQL. SQL would have to be the publisher and push via an OLEDB driver.

You can probibly do it pushing to SQL but this would be a question for an AS400 forum.

Martin