RE: [IMail Forum] External database

[Scott A. Keen]

Thanks for the reply.

 

>> 1: don't bother creating the table yourself if you are creating a new domain. Let Imail do it for you. 

OK, I deleted the table. 

 

>> 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.

OK. It was set up correctly. Connect Test is successful.

 

>> 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.

Yes, the Administrator is the logged in user. I added the Administrator to the Users of the database, and enabled all the access rights.

 

>> 4: good luck

Thanks. Still can't get it to work.

 

 

-----Original Message-----
From: Andrew Cocker [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 10, 2000 11:59 AM
To: [EMAIL PROTECTED]
Subject: RE: [IMail Forum] External database

 

-----Original Message-----
From: Scott A. Keen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 10, 2000 9:43 AM
To: '[EMAIL PROTECTED]'
Subject: [IMail Forum] External database

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