Setting Up Client Access ODBC Datasources

In you have Client Access for Windows 95/NT or Client Access Express, you can use the ODBC provider from IBM for communicating with your AS/400.  First, you need to ensure that the ODBC driver has been installed on your system.  To do this, run the Selective Setup program that is in your Client Access folder.  Once selective setup gets going, you should see a screen like that shown below.  If ODBC is checked, as it is in the example screen, you are ready to proceed.  If ODBC is not checked, you should check the ODBC box and continue with selective setup to cause ODBC to be installed.

If ODBC is not checked on your machine, checking it will cause ODBC to be installed.

Once ODBC is installed on your machine, you need to set up an ODBC data source so that the SQLThing program can communicate with your AS/400. To do this, select Settings and then Control Panel from your Windows Start menu. Once the control panel is open, double click on the ODBC Data Sources (32-bit) icon to start the ODBC Driver Manager. (If you are running Windows 2000, double click the Administrative Tools icon and then double click the Data Sources (ODBC) icon). Once Driver Manager is started, you should see a screen like the one below.

Click the Add button and you will be presented with a screen that allows you to choose the driver that you want to configure.  Select the Client Access ODBC Driver (32-bit) from the list and then press the Finish button.  You should be presented with the screen shown below.

This control panel applet lets you set all of the properties of you new data source.  First and most important, you need to name the data source.  I recommend you use the name MYAS400 as shown above.   Under the AS/400 System dropdown list, enter or pick the IP address of the AS/400 that you will be talking too.  Next, I recommend that you select the Server tab and then enter a list of libraries that you would like to be your default libraries in the Library List field. 

Next, select the Performance tab and make sure that the Extended Dynamic checkbox is not checked.  If this box is checked, ODBC will package all of your SQL statements on the AS/400.  Right now, you do not want to use packages so make sure that the check box is unchecked.  Finally, press the OK button to apply your settings and save this data source.