使用.NET连接到AS400

Install-Package IBM.Data.DB2.iSeries

using IBM.Data.DB2.iSeries;
using System.Data.Common;

string connectionString = "DataSource=AS400_IP_ADDRESS;UserID=USERNAME;Password=PASSWORD;DefaultCollection=LIBRARY_NAME;";

using (iDB2Connection connection = new iDB2Connection(connectionString))
{
    connection.Open();

    string sql = "SELECT * FROM TABLE_NAME";

    using (iDB2Command command = new iDB2Command(sql, connection))
    {
        using (DbDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 读取数据
            }
        }
    }
}

Install-Package System.Data.Odbc

using System.Data.Odbc;

string connectionString = "Driver={iSeries Access ODBC Driver};System=AS400_IP_ADDRESS;Uid=USERNAME;Pwd=PASSWORD;DefaultLibraries=LIBRARY_NAME;";

using (OdbcConnection connection = new OdbcConnection(connectionString))
{
    connection.Open();

    string sql = "SELECT * FROM TABLE_NAME";

    using (OdbcCommand command = new OdbcCommand(sql, connection))
    {
        using (OdbcDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 读取数据
            }
        }
    }
}

Install-Package System.Data.OleDb

using System.Data.OleDb;

string connectionString = "Provider=IBMDA400;Data Source=AS400_IP_ADDRESS;User ID=USERNAME;Password=PASSWORD;Default Collection=LIBRARY_NAME;";

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    connection.Open();

    string sql = "SELECT * FROM TABLE_NAME";

    using (OleDbCommand command = new OleDbCommand(sql, connection))
    {
        using (OleDbDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 读取数据
            }
        }
    }
}