Architect definition file

Architect requires a channel definition to connect to the database. The channel definition is defined in the Architect definition file (.adb). This file represents the database.

When you create a database, the wizard automatically creates a definition file. To open the database you created, start Architect, click Open an existing definition file, and select the .adb file that matches the name of the database. You can save this file to another name as long as the extension is .adb.

The [Application] section sets the name of the application to BudgetPLUS. This should not be changed. The AlphaOrderMemberLists setting determines whether certain Budgeting member selection dialogs display members in the database order (for example, Mem_ID order), or in alphabetic order.

The [ServerConnection] section specifies the channel name to use with this database. The TimeOut setting defines the number of seconds Architect waits for a connection to the server. If Architect cannot connect to the server within that amount of time, a message appears indicating that the program could not connect to the server.

The [DataLoader] section specifies the Data Loader channel name to use with this database. Architect uses the ODBC DSN specified in the <database reference> to connect to the database during startup.

The [CHANNELS] section sets the information needed to establish connections with the Architect channel. Each production database must have a unique channel name. This is the syntax for Channels entries:

<channel name>=<communications method>(<application server address or name>,<port>,<database reference>,<placeholder>,<placeholder>,<data source type>,<engine type>)

Where:


Item	Description
`<channel name>`	Alias used only to reference the connection information.
`<communications method>`	TCP/IP.
`<application server address or name>`	Computer name or TCP/IP address for the machine providing the Application Server.
`<port>`	Port number for TCP/IP. This is established during installation of the Application Server.
`<database reference>`	Database server name and schema name combination. The Database Server string of the Channel definition contains both Database Server name and Schema name formatted into one string using the delimiter '.' as follows: `<DatabaseServerName>.<SchemaName>` The schema name is always the name of the schema that the user of the Database Wizard specified as the production schema.
`<place holder>, <place holder>`	Must remain in this setting.
`<data source type>`	MSSQL_DBTYPE or ORACLE_DBTYPE, identifying SQL Server or Oracle respectively.
`<engine type>`	Defined as Architect in one channel line, and as DataLoader in another channel line. These settings should not be changed.

The [User] shows the name of the last user who signed on using this file. The password is used only for schedule download. The user must run Architect once for the password to be included in this file.

The [LocalCache] section defines where to store the local structure for the database represented by this ADB file. It is important that you have different local caches for each ADB file. By default, the path is set to the CACache directory.

The [Formula Builder] section controls the use of color. The UseColors setting of this section turns the color coding on and off. There are also settings for each line type.