Specify the ODBC data source

You must specify the IBM i Access ODBC data source for your application to access and manipulate data.

To specify the data source:
  1. Start the ODBC Administration program from the IBM i Access Client Solutions program group.
  2. Select the appropriate tab for the type of data source. See Overview of the IBM i Access ODBC driver for more information.
  3. Select an existing data source from the list, or select Add to create new one. If you are using an existing data source, click Configure and proceed to step 5.
  4. Select the IBM i Access ODBC driver for your data source, and click Finish.
    Start of change
    Note: You might notice the Client Access ODBC Driver (32-bit) or iSeries Access ODBC Driver names in the list of drivers. These names are listed so that data sources created with previous releases of Client Access will continue to work. All names point you to the same ODBC driver. Although you can use the previous names, in future releases the previous names will be removed.
    End of change
  5. Specify desired options using the IBM i Access ODBC setup dialog. For a description of the controls, refer to the data source's online help by using the F1 key or the Help button.
Note: The data source name can include up to 32 characters, must start with an alphabetic character, and cannot include the following characters:
Unallowed data-source characters
Left bracket ([) Question mark (?)
Right bracket (]) Asterisk (*)
Left brace ({) Equal sign (=)
Right brace (}) Exclamation point (!)
Left parenthesis (() At sign (@)
Right parenthesis ()) Semicolon (;)