I just went through the same thing earlier this week. With the help of Ron
from Humankind, I was able to get it working.
Create a tablespace in Enterprise Manager
Set SQL Server to do SQL authentication, not NT authentication.
Create an SQL user with permissions to the tablespace you created.
Create a system DSN, use the SQL user you created. Don't forget to set
TCP/IP as the method if you are not on the same machine.
Test this DSN.
Open IMail Administrator.
Select the domain and select external database.
Configure the external database.
Here's my example data:
Mailserver- veena.ttiweb.com
DSN name- ImailDB
SQL user- ImailExtDb
SQL User pw- a123
The IMail Administrator set up looks like this:
ODBC System Data Source Name:
IMailDB;uid=IMailExtDb;pwd=a123
Table name:
veena_ttiweb_com
All has been fine. Hope this helps.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Rames Bist
Sent: Friday, June 16, 2000 4:35 AM
To: [EMAIL PROTECTED]
Subject: RE: [IMail Forum] External database connection
With the following DLL Still I am not able to connect to SQL Database. The
Imail is not able to pickup the user information from the SQL database. Can
anyone help me?
Ramesh
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Len Conrad
Sent: Friday, June 16, 2000 11:50 AM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] External database connection
>I am deploying IMail Server 6.0 with an SQL 7.0 database to store the User
>credentials ( SQL server is installed on a different server). I need to
>authenticate the user with reference to the Credential stored in the SQL
>database. Can anybody help me on this? I would appreciate if any body, who
>has deployed similar setup, could provide me the required ODBCUser.dll.
Use this odbc driver with MS SQL 7 http://home.worldnet.att.net/~niceman
Len
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.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
