iseries As/400 Setup In Windows Operating System And Accessing Its Database

iSeries is an IBM product, formerly known as AS/400. It is not an open source. You have to buy its licence to work with this product. Let's say, you have this product already and you want to communicate with this product in Windows operating system.

Let's say the requirement is, you want to design one Web Application, using .NET framework, where the database is iSeries AS/400. To communicate with iSeries AS/400 database, you have to follow the steps, given below, to configure iSeries AS/400 in Windows platform. As I said, iSeries AS/400 is not a free version, so consider that you already have this product in the path, given below:

...\iSeries\iSeries Access {version}

  1. Install iSeries Access {version} from the following path:

    ...\iSeries\iSeries Access {version}

  2. Open Control Panel

    Control Panel

  3. Now, go for System and Security selection.

    System and Security

  4. Go for Administration Tools selection.

    Administration Tools

  5. Select Data Sources (ODBC) and double click it.

    Data Sources

  6. Click Add button to add new User DSN or System DSN. The difference between these two options is that, if you choose User DSN ,it will work only for a user for whom you configured. If you go with System DSN, it will work for the system, irrespective of any user. After selecting either User DSN or System DSN,it will give an option to Add new DSN. Once you click it, it prompts you for the selection. Go for Client Access ODBC Driver (32-bit) option and hit Finish button.

    Finish

  7. A Window will prompt. Enter Data Source Name as "****", System as "********".

    Data Source Name

  8. Now, go to "Server" tab. Enter the library list as "TEMP XYZ490BD1 XYZ6490BS XYZ490BDF XYZ490BD XYZ490BI XYZ490BQ XYZ490BP XYZ6490BD XYZ6490BQ XYZ6490BP QXYZ" Here, "TEMP"," XYZ490BD1", " XYZ6490BS" etc. are the library lists , where the database objects (Tables, Stored Procedures and Functions etc.) resides. Hit Apply button and then hit OK button.

    Server

  9. If you observe, User DSN is being created with the name "****".

    User DSN

  10. Add the following connection string to your Application to access the database.

    code

    Sample C# code to communicate with iSeries AS/400 database given below:

    code

Note: Please consider that, in this article a few keywords may match online.