An easy to test IP address and ports for DataGate

When you have trouble connecting with DataGate for IBM i (especially for new or upgraded installations) the first thing you check is the IP address and the TCP/IP port. This article shows a good way to do that. DataGate for IBM i needs a TCP/IP port to work. By default, DataGate uses port 5042, but […]

How to upgrade ASNA DataGate WebPak

The ASNA WebPak is the DataGate client for Windows Servers. It is to Windows servers what the Client Deployment binary is to Windows clients. The WebPak should be installed on any Web server on which you’ve deployed an AVR ASP.NET Website/Web services or Monarch migrations. Installing WebPak is very simple; you just run the WebPak’s […]

Using IBM’s Open Query File with ASNA Visual RPG

Finding records where a field contains a given value is an awkward thing to do with RPG’s record-level access. In either green-screen RPG or ASNA Visual RPG (AVR), the ugly solution is simple, loop over every record in the file checking each field as you go. This works, but have something nearby to keep you occupied while you wait. This article provides an alterative to that record level access using AVR for .NET’s Open Query File.

Installing a second instance of DataGate for IBM i

Please read these instructions completely to ensure a successful co-existing install of ASNA DataGate for IBM i. If you have any questions, please contact us at or give us a call before you start your installation. You can install DataGate while another instance is running, but if possible, we recommend the orderly shutdown of existing […]

Using SQL to help identify ASP.NET orphan IBM i jobs

This article provides a potential way to identify orphan IBM i jobs as a result of Database connection leaks in ASP.NET Web applications. We’ve written before about the perils of orphan IBM i jobs before. This article and video discusses a potential way to identify orphan IBM i jobs and this older article also discusses techniques for avoiding […]

How to change the TCP/IP port that DataGate for IBM i uses

This article explains how to change the TCP/IP port that DataGate uses. See this article for a list of other articles that may be helpful for this task Why would you ever want to change the TCP/IP port? In normal circumstances, you’d generally not ever need to do this. However, consider the scenario of updating […]

ASNA Pipeline #4 2021

This newsletter features a Web site that every IBM i manager should read, an upcoming Webcast, some programming tips, a cool new Windows utility, and a great book deal. Happy Holidays All of us at ASNA wish you and yours the happiest of holidays and a very good new year! Take your RPG programs from green […]

ASNA Pipeline #3 2021

Issue: #3/2021 A tip for changing your application’s database name at runtime and a refreshed version of DataGate for IBM i 16.x are featured in this issue of the ASNA Pipeline. Change an app’s DB name at runtime — without recompiling This article shows how to change a Web or Windows application’s database name at runtime, […]

Change an app’s DB name at runtime — without recompiling

I’ve seen some crazy code lately that enables the ability to change an application’s database name at runtime. Much of the code I’ve seen makes this way harder than it needs to be. This article provides a simple way to be able to dynamically change your Web or Windows application’s runtime database name without recompiling […]