How do I access Oracle 8i data on an NT4 box

[Guest.Visitor]

I need to access live data from an application using Oracle 8i on NT4 on our integrated PC server. What steps do I need to perform on the AS/400 to import it. I looked at ODBC connectivty options but it is only through Client Access. Is there direct access method from the AS/400 to Oracle ?

[Guest.Visitor]

I am looking into a similar situation with my company. I need to access data on an Oracle server as well as a SQL server. From my research to date, the only way to access the data on an Oracle server is by purchasing a software package from Oracle called Access Manager. This software resides on the AS/400 and performs the conversions. If you find any more information, please let me know. I will also let you know how our endeavor goes. Good luck! Rob Frank rob.frank@mtdproducts.com

[Guest.Visitor]

You need to buy a software to do it. But for an average size files, VB program using OLE DB for AS/400, Oracle, SQL Server will work. You can connect to all 3 databases inside one VB program.