Paul,
I am just using one domain, but you could apply this solution to multiple
domains. Also you might want to try Dave's utility first to see if that
solves your needs.
We have a web site that people register to, Imail is just one of the many
features member receive. As people register, a SQL 7 db is populated with
their personal info as well as other site settings. Since we wanted their
Imail accounts to have the same username and password, we decided to use the
information already in the SQL db. In the SQL manager, I created a new view
that would grab their name, password, Imail sizes etc. Then I had Imail
point to this view using its external database option. Imail sees the View
you created as just a table. Now whenever a person's password changes, so
does the password in the view. I'll include the code I used to create the
view.
CREATE VIEW dbo.IMail
AS
SELECT loginid AS userid, password,
firstname + ' ' + lastname AS fullname,
'd:\imail\users\' + loginid AS userdir,
loginid + '@domain.com' AS mailaddr, imailmaxsize AS maxsize,
imailmaxmessages AS maxmessages, imailflags as flags, 0 AS type
FROM persinfo
-----Original Message-----
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 12, 2000 4:39 PM
To: [EMAIL PROTECTED]
Subject: RE: [IMail Forum] Converting standard iMail Host to external db
host
Ryan,
I have been out of town a couple of days and just saw your response to my
question of last week. I'm not sure what you mean when you say I need to
"create a View to grab the proper data." I want to use MSSQL Server 7 as the
user database. Currently I have several domains that are set up as standard
iMail hosts (i.e., not using an external db for user info). How would I go
about moving all the data on current users to MSSQL in order to convert
existing domains to external db domains?
Thanks for any more insight.
Paul Sinclair
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Marotz
> Sent: Thursday, June 08, 2000 12:19 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: [IMail Forum] Converting standard iMail Host to external db
> host
>
>
> If you are using SQL to hold the user info, you can create a View to grab
> the proper data from the user database.
>
> -----Original Message-----
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 06, 2000 6:45 AM
> To: [EMAIL PROTECTED]
> Subject: [IMail Forum] Converting standard iMail Host to external db
> host
>
>
> I have a domain that is currently set up as a standard iMail host. I would
> like to convert this to a host that draws its user information from an
> external database. Is it possible to do this without having to reenter all
> the user information into the new database or will I have to enter all the
> existing UserID/Password information into the new database?
>
> Paul Sinclair
>
> 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.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
