One little hint on errors. If they (SQL Errors) occur they will be written to the sysmmdd.txt in the IMail Spool directory.
Eric S ----- Original Message ----- From: "Norman J. Nolasco" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 26, 2002 1:31 AM Subject: RE: [IMail Forum] New Thread - SQL and IMail - Archives have been useless > > 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/ > 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/
