You must specify the IBM® i Access ODBC data source
for your application to access and manipulate data.
To specify the data source:
- Start the ODBC Administration program from
the IBM i
Access Client Solutions program
group.
- Select the appropriate tab for the type of
data source. See Overview of the IBM i 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 IBM i Access ODBC driver
for your data source, and click Finish.
Note: You might 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 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 (;) |