Thanks to one of the list members, I was able to get SQL 7 to work with IMail. He pointed me at the following knowledge base article...
http://support.ipswitch.com/kb/IM-19990623-DM03.htm
Specifically...
>Problem 5: >We recommend that you configure the database in the following order rather than just working through the IMail >Administrator: > >1. Go to Control Panel > IMail Server > Global > Virtual Host Admin. >2. Click on the domain >3. Choose an external database. >4. Click SAVE before going to configure. >5. Click on configure. >6. Specify the System DSN. If you need a username and password use: >dsn_name;UID=username;PWD=password. >NOTE: If you need to use a username that user must have a password. Both >UID and PWD must be specified. >7. Specify a nonexistent table name. >8. Save the changes and exit. >9. Now go to the IMail Administrator and add a user.
Also, the DB=databasename is not required, IF in the DSN you force it to change the database to the proper database.
I will have to try it for awhile to find out if it is stable, though.
Deen Foxx Director of Technical Services deen@yourhost.com
Executive Web Services www.yourhost.com