Specify the ODBC data source

You must specify the iSeries Access ODBC data source for your application to access and manipulate data. To specify the data source:

Start the ODBC Administration program from the System i Access for Windows program group.

Select the appropriate tab for the type of data source. See Overview of the iSeries Access ODBC driver for more information.

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.

Select the iSeries Access ODBC driver for your data source, and click Finish.

You may notice the Client Access ODBC Driver (32-bit) name in the list of drivers. This name is listed so that data sources created with previous releases of Client Access will continue to work. Both names point you to the same ODBC driver. You can use either name, however in future releases the Client Access ODBC Driver (32-bit) name will be removed.

Specify desired options using the iSeries Access for Windows 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.

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 (;)

Parent topic:

Set up your system for the iSeries Access ODBC driver

Related tasks
Use independent ASPs through ODBC