We have a very similar problem, except we are using oracle. Our problem
manifests itself when the db is brought down for backup. Until the imail
services are restarted, all logins fail to authenticate. For what
ipswitch's tech support has told me, the problem here is that imail is too
stupid to realize that the odbc connection is invalid and reset itself. The
frustrating thing is that last night a tech support manager told me that
this is my problem and there will be no fix. They argue that there is no
reason to bring down a database to back it up. While I might agree, it is a
fight I cannot win against our dba's, since they do not what to do hot
backups.
The ideal solution would be if imail was smart enough to monitor the db and
reset the odbc connection if necessary.
Our current solution is to write a batch file that calls net stop and net
start when the db is back up.
Keith Rachunok
PaeTec Online, Inc.
[EMAIL PROTECTED]
>From: "Jeffrey B. Marsh" <[EMAIL PROTECTED]>
> Date: Thu, 14 Oct 1999 09:38:03 -0700
> Subject: [IMail Forum] ODBC and IMail
> Reply-To: [EMAIL PROTECTED]
> Hello everyone,
>
> We have the latest version of IMail running on one machine.
> We have two
> domains defined. The main domain uses the NT authentication. The other
> domain uses a SQL Server 7 ODBC connection. SQL Server is on another
> machine. We haven't really pinned it down absolutely as being the only
> cause, but it seems that every time the machine running SQL Server is
> rebooted, the domain using ODBC, locks up - can't receive email to any
> mailbox or send mail from any mailbox (not sure if "locks up"
> is the correct
> phrase). The domain using NT authentication continues to work
> fine. When we
> restart the SMTP, POP3, IMAP4, and WEB services, the domain using ODBC
> starts to work again. We can duplicate this at will. Does
> anyone have any
> experience with this? Is there a solution to this problem?
> Any help would be
> appreciated. Thanks.
>
> --
> Jeffrey B. Marsh
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
