ODBC4x
Logon Local & Client Configuration
  Default values can be set in the Company code, User ID, Password and Session ID fields for use in the definition of data file pathnames. Whenever a data file pathname starts with an equal sign (=) the pathname will be scanned.

All occurrences of %C$ will be replaced with the value set in the default company code, %U$ will be replaced with the default user ID and %S$ will be replaced with the default Session ID. The search for occurrences is case-insensitive, thus %c$ and %C$ will both be found and replaced with the value of the company code field.

When using Sage MAS 90 (or Sage MAS 200) data files, the ODBC driver will prompt the user to enter a valid company and user ID when invalid data is used during a database connection. For other databases, enter a question mark ? in any of the optional fields during the DSN setup and the driver will prompt for the values during a database connection. There is no validation of the values entered.

The following optional fields are found under the Logon tab of the setup dialogue:

Company code: Optional value to replace occurrences of %C$ in a definition pathname. Maximum length is 127 characters.
Default User ID: Optional value to replace occurrences of %U$ in a definition pathname. Maximum length is 64 characters.
Password: Optional password value —used in conjunction with a Sage MAS 90 or Sage MAS 200 system only. Maximum length is 63 characters.
Session ID: Optional value to replace occurrences of %S$ in a definition pathname. Maximum length is 15 characters.

This parameter provides the ability for applications to create temporary files that can be accessed from an ODBC application. Once the temporary file has been generated, the complete file name, or a portion of the name can either be manually entered into the DSN information, or sent to the driver programmatically using a connection string.