View Full Version : Recognize AS/400 system in MS SQL 7 server.
01-01-1995, 02:00 AM
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.
09-25-2000, 03:23 AM
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
09-25-2000, 03:32 AM
Dear Dave, Thanks your reply, but I'm new on SQL7, could you introduce some reference sites or books which I can refer to.
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.