Using Multiple Relational Database Support
Multiple database support allows iFIX ODBC to execute commands in different databases. Implementing multiple relational database support allows you to:
- Use different user name/password combinations in a database.
- Communicate with several different relational databases.
- Store all SQL commands in one database and execute the commands in several different relational databases.
NOTE: The methods of storing SQL commands and using multiple relational databases discussed in this chapter cannot be mixed.
This chapter includes the following sections:
- Managing Multiple SQL Connections
- Using Multiple User Accounts
- Using Multiple Databases
- Storing Commands Centrally
