--Gary Walworth
Beachlink
Kitty Hawk, NC
> I second this. I have been waiting for this feature since I dropped
> Post.Office!!!
>
>
>
> Dale and Others:
>
> Ipswitch, makers of Imail has just released version 5 which
> includes support
> for ODBC auth and other features.
>
> www.ipswitch.com
>
> This is what we will be upgrading to, in addition to currently eval'ing
> Emerald.
>
> I hope Dale might find the time to possibly incorporate Imail as
> an External
> System like NTMail.
>
> Mike K
>
>
> Below is the ODBC info from IMail support for Dales' perusal:
>
> EXTERNAL DATABASE INTERFACE
> ===========================
>
> Description
> -----------
> IMail 5.0 provides a means of interfacing with external
> database through a dynamic link library that is defined
> for each host.
>
> This external user database is designed to be used with
> ODBC, but in reality it can support any method of external
> database by modification of the "odbcuser.dll". The
> complete source for this DLL is provided upon request
> from Ipswitch or on our web site.
>
> IMail supports the use of up to 10 different DLL's. Using
> our provided DLL, you can have an unlimited number of
> tables within a DLL. Each DLL is loaded on demand and
> remains loaded after first load until all applications
> using IMAILSEC.DLL are stopped.
>
> Configuration
> -------------
> Specifically, in the IMail control panel applet, Global
> tab, press the Virtual Host Admin button. For each
> defined host you have a choice of one of three user
> databases:
>
> 1. IMail User Database
> 2. local NT User Database
> 3. External User Database
>
> When you select the "External User Database", the
> "Configure..." button is activated. Pressing the configure
> button presents a dialog where the external database is
> defined.
>
> The first option is where you specify the FULL pathname
> to the DLL that exports the following functions:
>
> GetUserEntry
> SetUserEntry
> DeleteUserEntry
> AuthorizeUser
> GetFirstUserEntry
> GetNextUserEntry
>
> (refer to the "odbcuser.h" file for full explanation of
> these functions.)
>
> The second option is where you specify the ODBC System
> Data Source Name for the database where the user information
> is stored.
>
> The third option is where you specify the table name for
> the data. This defaults (if the field is blank or contains
> "[default]") to the host name with periods replaced by
> underscores.
>
> These three options are written to a registry entry under
> the domain named "AuthDatabaseDLL". The three entries are
> concatenated with an asterisk (*) as the separator.
>
> Default ODBC Tables
> -------------------
> The default ODBC table consists of 7 entries:
>
> USERID - text
> PASSWORD - text
> FULLNAME - text
> USERDIR - text
> MAILADDR - text
> MAXSIZE - integer
> MAXMSGS - integer
> FLAGS - integer
>
> The provided implementation expects these entries to be
> in sequence. Additional information (after flags) MAY
> exist in the table.
>
> Modification of the ODBCUSER.DLL
> --------------------------------
> The source for ODBCUSER.DLL is provided in the ZIP
> file "odbcuser.zip".
>
> Any language may be used to write the ODBCUSER.DLL
> provided it exports the necessary routines with the
> proper arguments and calling stack type. The provided
> source and project files are written for MS Visual C++
> 4.1. Please refer to "odbcuser.h" and "codbc.cpp"
> for additional information.
>
> Table modifications may be made in "CreateTable",
> "InsertUser", "UpdateUser", and "GetUser". Note
> that entry sequence is defined in "CreateTable"
> and "GetUser".
>
> Note that this DLL can be named anything you wish
> and the name of the dll must be relayed to IMail
> as specified under "Configuration" above.
>
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html