> I have been hunting for step by step, DETAILED and CLEAR instructions for
> setting up IMail to use SQL as its database. However, nothing I have
found
My initial problems with setting up SQL for IMail were related to my
(erroneous) thinking that it was a lot harder than it really is. It's
pretty
straighforward, actually. You don't need to worry about table fields at
this
stage.
> setup, etc. I have found bits and pieces and can get IMail to see the
> database, but, then seem to have the wrong structure. Is that an overall
This wouldn't be a perfect production setup, but try this for starters just
to get it to work:
Assuming you have an empty database in MS SQL with an "sa" account.
1) Setup a DSN that points that your empty db just as you would for any
ODBC.
Call the DSN "IMAILSECDB". I don't know if it makes a difference, but I
used "System DSN"
When you've tested your DSN and it works:
2) Open the "IMail Administrator"
3) Add a host -> You should get the "Create New Virtual Host" wizard
4) Click "Next >" -> You should get the "New Host Name" window
5) Host Name: whatever your host name is (mail.example.com)
6) Select "External Database" and click "Configure"
For "External Database Implementation DLL" use:
D:\IMail\odbcuser.dll
For "ODBC System Data Source Name" use:
IMAILSECDB;uid=sa;pwd=yourpassword;
For "Table name" use:
[default]
7) Click "OK" when you're done.
8) Go through the rest of the wizard normally.
You won't get any error messages if there's a problem. The way you see if
it
worked out is that IMail should have created a table in your empty database.
I guess you could also check the SQL logs... but that might entail looking
up the error codes on msdn.microsoft.com.
If you didn't get this far, let us know what part of these steps is unclear
or gave you a problem? If you weren't able to test the DSN connection or
it kept failing, feel free to ask more questions about the process.
If the table was successfully created, try adding a user through the admin
interface. You should see a new user record in the table.
Most problems either stem from insufficient permissions, incorrect ODBC
settings, or not enough sleep. :)
-Norm
To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html
List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
