---

Connecting to a Database

This chapter describes how an Enterprise Objects application connects to a database and how you can take control of this process. You may want to manually connect to a database for a few reasons:

• Your application has an audit tracking requirement.

• Different users have different levels of access to the database.

• You need to better secure database login information.

• You need to limit the number of open connections to a database.

This chapter is divided into the following sections:

• “Objects Involved in a Database Connection” describes the objects involved in connecting to a data source.

• “When Database Connections Are Opened” discusses when database connections are opened and how they are reused.

• “When Database Connections Are Closed” discusses when database connections are closed and how to take control of this mechanism.

• “Connection Dictionary” describes the connection dictionary that Enterprise Objects uses to connect to a data source and the different ways to provide it.

• “Database Channels” discusses the default configuration of database channels in Enterprise Objects and how to customize it.

• “Connecting to Multiple Data Stores” discusses Enterprise Object’s support for accessing multiple data sources in an application.

• “Providing a Connection Dictionary in Code” tells you how to provide a connection dictionary programmatically.

• “Providing Multiple Database Channels” tells you how to provide multiple database channels in an application.

• “Closing Database Channels” tells you how to monitor the number of open database channels and close them as needed.

---