Item <server>

Table 39.3. Item's attributes <server>

Attribute nameDescription
type=Database server type. You can set the following values:
  • oracle - Oracle 8i, 9, 9i

  • oracle_cuzk - Oracle ISKN (for COSMC)

  • mssql - Microsoft SQL Server

  • mysql - MySQL server

  • msaccess - Microsoft Access

db=Name of the database or service GROMA shall connect to. You can use the variable db in the connecting string.
driver=Name of the ODBC driver as defined in the ODBC settings in the control panel. You can use this under the variable driver in the connecting string
connect=Connecting string for connection to a database. The syntax of the connecting string depends on the type of the database server, the details can be found in the documentation to the pertinent ODBC driver. A variable representing some values can be used in the connecting string. The variable name must be enclosed by the characters # in the string. You can use the following variables:
  • driver - Name of the ODBC driver (attribute driver of the itemserver)

  • db - Name of the database or database service (attribute db of the item server)

  • uid - Login name (entered in the login dialog)

  • pwd - Login password (entered in the login dialog)

Example: connect="DRIVER={#driver#};DBQ=#db#;UID=#uid#;PWD=#pwd#;DBA=W"

Table 39.4. Item's structure <server>

The item <server> contains only attributes.