Post reply

SQL Server and AS/400

  • August 28, 2003 at 10:24 am

    #358236

    Hi

    Here's the plan, to use an ASP.Net front end to a SQL server that is the middle tier between the web and AS/400. I would like to hear from anyone with any experience or ideas about the how's and why's needed to make this happen. I know little about AS/400 and possibly even less about why they want this done. Any info is appreciated. Thanks

  • September 1, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • September 2, 2003 at 1:41 am

    #472157

    Take a look at IBM Client Access Express software, installed on the server it enables you to connect to AS400 and download data to SQL or can be used to establish a linked server connection to the AS400. This is one option !

  • September 10, 2003 at 9:26 am

    #473458

    We did something like that ..... Used IBM's MQSeries product to transmit data from the web to AS/400 ........ Maybe IBM's WebSphere would help too ?

  • September 10, 2003 at 9:47 am

    #473476

    We have our ERP systems running on AS400's and are running .NET applications from SQL. We have created DTS packages which extract data out of the AS400 through an ODBC connection and Client Access Express.

  • September 10, 2003 at 10:50 am

    #473497

    Thanks! I'll check all of those options out.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply