Connect to as400 using sql

I've found this question during my search.

You can connect to the IBM iSeries using OLEDB connection and run SQL queries then retrieve the results but you need some steps first.

1. You need the AS400 .Net data provider. - http://www-03.ibm.com/systems/power/software/i/access/windows/dotnet.html

2. You need to write your connection string. - http://www.connectionstrings.com/as-400

3. Some Code, then

   string ConnectionString = AS400ConnectionString;
   OleDbConnection _Connection = new OleDbConnection(ConnectionString);
   OleDbCommand _Command = _Connection.CreateCommand();
   
               string strQuery = string.Empty;
               strQuery += @"SELECT * FROM Contacts";
   
               if (string.IsNullOrEmpty(strQuery))
               {
                   throw (new Exception("No Library Setup"));
               }
   
               _Command.CommandText = strQuery;
               if (_Connection.State != ConnectionState.Open)
                   _Connection.Open();
   
               OleDbDataReader reader = _Command.ExecuteReader();
   
               while (reader.Read())
               {
                   //Your Logic
               }
   
               reader.Close();
               if (_Connection.State != ConnectionState.Closed)
                   _Connection.Close();