August 30, 2005 at 6:38 am
Has anyone done an ODBC connection to the AS400 that will allow the AS400 to directly insert, update, delete SQL Server tables? Is the primary configuration done on the AS400? What is involved?
August 31, 2005 at 8:10 am
I don't have any direct experience with this and I have a friend who wants to do the same thing. I suggested to her that perhaps she could use DTS? I would think that if you can make a connection to the AS400 from SQL Server using DTS then you should be able to perform the actions you want.
August 31, 2005 at 10:09 am
Hi,
You can do it using a LinkServer with ODBC or with DTS any of them has to work......
August 31, 2005 at 10:35 am
DTS works great and I suppose we'l go with that. I had prefered to design so that the iSeries controlled the inserts and population of the SQLServer database. DTS doesn't allow that - it merely gets the file to the server but the scrubbing, totaling, and updating of related tables still remains to be done....I have NOT tried Linker Server approach. If you have more info on that (is there setup required on both sides?) please forward. Thanks everyone!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply