Recognize AS/400 system in MS SQL 7 server.

[Guest.Visitor]

I intend to setup MS SQL7 server which to access AS/400 data and perform replication periodically. (AS/400 is data source for replication). Question: How can I access AS/400 data directly in MS SQL 7. I wish to replicate the changed records only, don't want to do the snapshot replication, since time consumming.

[Guest.Visitor]

There are three ways of which I am aware:<ul> An ODBC driver may be used (This is slow) You could use OLE - ADO. This is a separate install from the CA/400 CD-Rom, and can be cumbersome to work with. You could access the DRDA with the SQL CONNECT statement.[/list] There are probably other methods. Dave

[Guest.Visitor]

Dear Dave, Thanks your reply, but I'm new on SQL7, could you introduce some reference sites or books which I can refer to.