Thanks for the quick response.
Here is what I did:
1) Got Niceman's dll and installed it per his instructions.
2) Set the domain to use external database.
3) Applied it.
4) I already had a DSN setup for this database.
5) When into configuring the External DB. Told it the dsn name. Left the
table name to [default]
6) Added a user via Imail Admin
7) It added a user.
8) Looked at SQL 7 Enterprise Manager - noticed a new system table created
called dtproperties.
9) Had access look at it to see if there were any values. Nope, dead blank.
10) Went back into Imail Admin, checked the config of the db. Changed it
from [default] on the table to dtproperties. Can't add a user. I then
tried dbo_dtproperties. Same thing, can not add a user.
Now the interesting thing as well. Is that all these users that it can not
create are created somewhere. When I try to add that name again, seeing
that it failed, admin tells me that there is a name already taken.
Ideas?
dave
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ing. Andr�s E.
Gallo
Sent: Friday, July 28, 2000 1:34 PM
To: [EMAIL PROTECTED]
Subject: RE: [IMail Forum] SQL Integration
David:
First, to use SQL 7, get 'niceman' DLL. Works great. Find in the list the
link.
Second, create the domain, set to use Ext DB, but DO NOT CONFIGURE IT.
Apply, save et all.
Third, get into the domain with IMAIL Admin again, and THEN configure the
DB. Must be defined prior the System DSN, and with the proper rights if in
another box. ( ie Admin rights for each service POP3, SMTP and Web ).
Will create alone the table in the DB you pointed out in the DSN (default is
domain_com table ) with the proper columns. You can add later more columns
if you need.
good luck
The flags are explained in the database. 128 is the normal set.
Andres
-----Mensaje original-----
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]En nombre de David Bergerson
Enviado el: Viernes, 28 de Julio de 2000 14:31
Para: [EMAIL PROTECTED]
Asunto: [IMail Forum] SQL Integration
Hello,
I am new to the list and am evaling Imail. We are looking to do a front end
system for Imail that would require use of SQL Server. What I am trying to
do is to configure Imail to use an external db. There seems to be very
little documentation out there on it. I searched the KB and found out the
field names. I created a table, created an ODBC connection. I went into
Imail admin and chose the the table/db. Now when I go to add a user, it
tells me to check the external database settings.
What I am looking for is some more info! How do you get this to work, what
is the schema. How do you store the flags?
Thanks.
dave
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
