IMail supports multiple database connections. Enabling this feature will improve performance when using an external database. This can be enabled by creating and setting two registry keys:
HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\IMail\Global\UseMultiConnect
HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\IMail\Global\MaxConnect
The first key, UseMultiConnect should be set to 1 to enable multiple database connections. The second key,
MaxConnect should be set to the maximum number of connections allowed; 10 is recommended.
When installing IMail v8.2 or later over any version earlier than 7.1 in which one or more hosts are configured to use an external user database, new columns must be added to the database tables. This is due to additional user-level data which must be stored for use with the new Web Messaging features and for Web Calendaring. These new columns must be added to the user table for each IMail host configured to use an external database.
Notes:
If a custom ODBC driver was used with an earlier version of IMail, the driver must be modified to accommodate the new columns. Source code for the basic ODBCUser.dll driver (tailored for SQL Server and Access) may be obtained by download from the IMail Support Center:
ftp://ftp.ipswitch.com/Ipswitch/Product_Support/IMail/odbcuser.dll
These database column additions must be made before installing IMail v8.2. Also, if a custom ODBC database driver will be used with IMail, it must be created and ready for use. New columns and their types are as follows:
IMail Server 2006.1 New Columns
Database Column Name |
Type |
Default Value |
ENABLEALTWGSID |
INTEGER |
0 |
ALTWGSID |
VARCHAR |
255 |
IMail Server v7.1 New Columns
Database Column Name |
Type |
Default Value |
NUMNOTIFY |
Integer |
0 |
LASTNOTIFY |
Integer |
0 |
IMail Server v7.0 New Columns
Database Column Name |
Type |
Default Value |
NUMTRIES |
Integer |
0 |
LASTNOTIFY |
Integer |
0 |
ATTEMPTTIME |
Integer |
0 |
NUMTIMESSUSP |
Integer |
0 |
SPNDUSRACCT |
Integer |
0 |
IWOPTIONS |
Integer |
0 |
SPELLCHKG |
Integer |
0 |
ICALENBL |
Integer |
-1 |
SPELLENBL |
Integer |
-1 |
NUMSGSTNS |
Integer |
-1 |
IWDEPTH |
Integer |
-1 |
PRVWSIZE |
Integer |
-1 |
STRTDAY |
Integer |
-1 |
ENTRYGRNL |
Integer |
-1 |
STARTTIME |
Integer |
-1 |
ENDTIME |
Integer |
-1 |
MAXEVNTDISP |
Integer |
-1 |
MAXTSKDISP |
Integer |
-1 |
MAXNOTEDISP |
Integer |
-1 |
MAXDLYRCURCNT |
Integer |
-1 |
MAXWKLYRCURCNT |
Integer |
-1 |
MAXMONRCURCNT |
Integer |
-1 |
MAXRLYRCURCNT |
Integer |
-1 |
DISPCMPLTDTSKS |
Integer |
-1 |
HOURSCLOCK |
Integer |
-1 |
MAXSRCHRESPPG |
Integer |
-1 |
CONFIRMONDELETE |
Integer |
-1 |
TIMEZONE |
Varchar (255) |
"" (empty string) |
DEFVIEW |
Varchar (255) |
"" (empty string) |
DEFCALNM |
Varchar (255) |
"" (empty string) |
For all existing user records, these columns should be set to the default values shown in the table.