Step 1: download the latest ODBCUSER.DLL from ipwitch's ftp site. I had nothing but problems untill I did this.

Step 2: create a database and a DSN on the iMail server machine (if you havn't done this already). Test your DSN with something like an access linked table, interdev, or anything you have that can test the DSN.

Step3: Open ImailAdministrator, Select the IP of the host you want to set up, choose "external database" click "Configure"

the first box should contain the path to your odbcuser.dll

The ODBC datasource name needs something similar to the following (replace with the actual info for your database) This stuff is very poorly documented, and I had to dig realy deep to find it.

tablename, UID=sa,PWD=sqlpassword,DB=databasename

the tablename should contain the name of the table

Step 4: CLICK OK, then CLICK APPLY. This is an important step! Nothing will happen untill you hit the APPLY button.

Let iMail create your table for you, I had problems in trying to create one myself. I got it to work with the SQL server on the same box as iMail, but it *should* work with iMail on a different machine than the SQL server.

----- Original Message ----- From: Peter Salvage <wizard@sybaweb.co.za> To: <IMail_Forum@list.ipswitch.com> Sent: Friday, October 22, 1999 6:09 PM Subject: Re: [IMail Forum] Looking for help with SQL 7 Server...

> Mike > > Perhaps you'd like to share with us any config issues you came across? > Did you just point iMail at the DSN and it worked??? > > /wiZZ > > ----- Original Message ----- > From: Mike Hell <mikehell@kontrol.net> > To: <IMail_Forum@list.ipswitch.com> > Sent: 23 October 1999 02:46 > Subject: Re: [IMail Forum] Looking for help with SQL 7 Server... > > > I got it to work. What ya need to know? > ----- Original Message ----- > From: Deen Foxx > To: imail_forum@list.ipswitch.com > Sent: Friday, October 22, 1999 8:41 AM > Subject: [IMail Forum] Looking for help with SQL 7 Server... > > > If there is anyone on this list who has succeeded in getting Microsoft > SQL 7 server to work with IPSwitch's IMail, please reply. IPSwitch has > declined support for SQL 7 server but had mentioned that others have > gotten it to work. > > > > >