I am looking into using SQL as basically a front end to AS/400. Has anyone done anything similar? Does anyone know how to simply connect to an AS/400 from a dts or TSQL? What would I need to install, if anything? Any info is appreciated. Thanks
Probably need Client Access or some other driver on the server. We use it from app as well as DTS at J.D. Edwards/Peoplesoft with few issues. Tends to either work perfectly or fail miserably. Fortunately it works perfectly almost all the time.