Can someone
please tell me what I have to do to get IMail to work with an External
Database?
I've already
created the SQL Server database "IMAILSECDB", and created the DSN
"imailsecdb", and the table "myserver_com" with the fields as specified
(although I had no idea what field sizes should be).
When I try to
Add User, I get the message, "Cannot create user. Check external database
settings."
Any
suggestions?
Scott
That message
means you don't have
permissions to login to the database or that the dsn isn't pointing you in the
right direction.
1: don't bother creating the table yourself if you
are creating a new domain. Let Imail do it for
you.
IF you need to manually create the table then
:
USERID nvarchar 31
PASSWORD nvarchar 31
FULLNAME nvarchar 63
USERDIR nvarchar 255
MAILADDR nvarchar 255
MAXSIZE int 4
MAXMSGS int 4
FLAGS int 4
TYPE int 4
2: DSN Settings:
system dsn not file
dsn
Windows NT
authentication
'change default database to' set
to the database name you are using
Make sure you test the connection
from the setup wizard and that it connects
ok.
3: database
properties:
make sure that the NT user that is
logged in has admin privs on NT.
check the permissions for the
database you created. Make sure the NT user has read / write and create
privs.
4: good luck
