ODBC access to Iseries database

Adding ODBC Settings

To find the place where you set up ODBC settings, click on [START] » [Control Panel] » Administrative Tools » Data Sources (ODBC):

Administrative Tools

Click [ADD]

click add

Scroll down and choose "iSeries Access ODBC Driver"

Scroll down and choose iSeries Access ODBC Driver

Click [Finish]

Open each of the TABS along the top of the screen and match the settings 
as shown below.