![]() |
![]() |
![]() |
![]() |
Connection Options
The Database Editor has several other options to consider when connecting to a database. They are
- Set connection to be read-only to improve performance Database connections may be much faster if changes are not allowed to be made to the database. If this option is selected, it will prevent any changes from being made to the database. If the database will only be searched, this may be an acceptable limitation.
- Commit all changes immediately If this option is selected, changes made to the database take effect immediately. If it is not selected, changes made to the database are not made permanent until the "Commit" SQL command is issued.
- Connect to database automatically on program startup If this option is selected, the Composer will connect your application to the database automatically when the program is started. If this option is not selected, the application must manually connect to the database before it can perform any database operations.
In addition, databases may need other properties to be defined. For example, a username and password may need to be specified as properties. The bottom part of the Connection page lets you add new properties or modify existing ones. Every property consists of a name/value pair. Enter the name of the property (e.g. "username"), and the value (e.g. "anonymous"). New property pairs may be added to the list, and old ones may be modified or deleted. In either case, the changes are immediately visible in the area to the left.
At the bottom of the connection page is a button which connects to a database (or disconnects if a connection has already been made.) The space to the right of the button displays any connection-related messages. Note that this connection is separate from the database connection in the working model.
Data Representations, Inc. http://www.datarepresentations.com support@datarepresentations.com sales@datarepresentations.com |
![]() |
![]() |
![]() |
![]() |