ODBC

• Use File System - If set, the users.ini file will be used instead of an ODBC data source. This is the most efficient way to run the mail server and is ideal if the users that are not to be managed externally.
• Use ODBC - If set, an ODBC data source will be used instead of the users.ini. This is ideal for setups which require external control of users (from scripts and other applications) and also for clustering setups. The only information stored in an ODBC data source is the minimal information required for a user to exist. This means that ODBC mode still mainly uses the normal file system with the exception that the information normally stored in the users.ini is relocated to an ODBC data source.
• Connect String - This is the connect string which will be used to connect to the ODBC data source.
• Table - This is the name of the table which will used to store the user records.
• Domain Field - This is the field name where the domain string will be stored. The database must allow at least 100 characters for this field.
• User Field - This is the field name where the user string will be stored. The database must allow up to at least 100 characters for this field.
• Password Field - This is the field name where the password string will be stored. The database must allow at least 100 characters for this field.
• In Group Field - This is the field name where the in group string will be stored. The database must allow at least 100 characters for this field.
• Enabled Field - This is the field name where the enabled setting will be stored.
• Directory Field - This is the field name where the directory path string will be stored. The database must allow at least 255 characters for this field.
• Create Table - If this ODBC data source does not yet have the table created, this button will connect and create the necessary table and fields. It is recommended to create your table using this button as it ensures that the correct sizes are allocated to each field.
• Test Database - This will test the connect string specified to make sure that it is possible to connect to the ODBC data source.
• Convert File System to ODBC - This allows you to append all the users in the users.ini into the ODBC data source. This allows you to change between ODBC and File System modes without having to re-build your users manually.
• Convert ODBC to File System - This allows you to either overwrite or append all the users in the ODBC data source into the users.ini. This allows you to change between ODBC and File System modes without having to re-build your users manually.