You may want to use the same database for all transactions, but have different user name/password combinations. For example, an Oracle database can be configured for two users. One user has access to one set of tables, the other user to other tables.
To configure iFIX ODBC:
- Click the Start button and point to Programs, Administrative Tools, and then Data Sources (ODBC). You can also access the Administrative Tools folder from the Control Panel.
The ODBC Data Source Administrator program opens.
- Select the System DSN tab.
- Select the Add button. The Add Data Sources dialog box appears.
- Select the type of relational database you want to use and click OK. A dialog box appears.
- In the Data Source Name field, enter the data source name. For example, enter ORA_USER1. Make sure the data source name matches the name defined in your project.
- In the Server field, enter the name of your relational database server.
- Click OK or continue through the rest of the configuration.
- Repeat steps 3-7 to add another DSN. For example, ORA_USER2. Make sure that the information you enter matches the first DSN (since they are for the same database), except for the name.
- In the SCU, configure two SQL login accounts (one for each data source) and give each account a different user name and password.
- In the SQT blocks, in the Database ID field, create the iFIX database chains, defining the correct account, ORA_USER1 or ORA_USER2.
The SQL Task Configuration does not include a reference to a database identifier. Instead, you must define the Oracle account in each SQT block using the Database ID field.
When an SQT block triggers to execute a command using ORA_USER1, the SQL task logs into the relational database with the this user name and password. When an SQT block triggers to execute a command using ORA_USER2, the SQL task logs into the same database but with a different user name/password combination.
