David,
So far the help here has been good and I just wanted to say that in your
step 8, you should have seen one record for the user named 'root' created in
the new table. If that is not happening, then your setup is not yet correct.
IMail will always create that user in any new table as the first entry. If
that does happen, you are almost home!
Daniel Donnelly
Ipswitch Technical Support
________________________________________________________
See our Knowledge Base at http://support.ipswitch.com/kb
----- Original Message -----
From: "David Bergerson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 4:00 PM
Subject: RE: [IMail Forum] SQL Integration
> 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/
>
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/
