Well I purchased the template pack from human kind. This is just FYI and sql
works for me.
I have sql 7 on one machine, imail on another.
THE STEPS I TOOK:
Download the updated sql 7 dll from niceman (can't remeber the url but do a
search on google.com for "imail dll" and it pops up).
Create a database on the sql machine for your imail users or imail will use
the generic master database.
If sql is on another machine like mine is, create a logon on the sql machine
for the imail machine. Make sure it has read & write permission. Also make
sure it has ability to create tables.
>From the imail machine setup a system DSN (system NOT user DSN or it will
not work). Set authentication to sql not NT (I had to do this I do not knwo
why).
In imail setup a new host to test (virtual or otherwise). You will have to
save the config, before you select external database or one of the buttons
you need will be grayed out (imail bug). Anyway, select external database
option.
On the Name section be sure to include your exact DSN sql login, password
and the database you wish to use. (if you don't know syntax, goto imail
knowledge base and search from "imail sql" and it is there.
Now, if you use human kinds ezsignup template set (www.hksi.net), it is
setup to use an external database just follow the instructions in embedded
int the template. You will need to put in your domains, the sql login, etc.
Now drink some wine and say a prayer to the Gods of old. Dancinf naked under
a full monn may help (I did not try it, but I can't dance).
It should work. It did for me. "Niceman" (mike I think) says his dll should
work with a heavy load, 100,000 users or so on a big machine, with sql
separate and perhaps using len's gateways to offload some of the processing.
Sorry if I rambleda bit, but I am a newbie to all this, and the obvious to
most, was not obvious to me, so I included more detail than I have seen here
before.
Cheers
----- Original Message -----
From: "Muhammed Amir" <[EMAIL PROTECTED]>
To: "IP_Switch_List" <[EMAIL PROTECTED]>
Sent: Thursday, July 06, 2000 10:00 AM
Subject: [IMail Forum] Using External Database
> Hi All,
>
> I am facing problem in using my external database i.e SQL Server 7.0 with
> imail for user login and , can anyone make me sure that it will be
possible
> to do it, and also give a little hint also to help me how to do it , i
will
> appreciate !
>
> I am new with imail, provided i am recieving and sending emails using
Imail
> successfully.
>
>
> Muhammed Amir Jaleel
> Development Manager
> FOHMICS Inc.
> Address : http://www.fohmics.com
> Email : [EMAIL PROTECTED]
> Phone : +(971)-2-6652999
> Fax : +(971)-2-6679696
> Cellular: +(971)-50-4822391
>
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
