Still working for me today too!!!
Bruce
----- Original Message -----
From: Robert J. Fehn Sr. <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 30, 2000 12:19 PM
Subject: Re: [IMail Forum] Robert, this was sent to the group earlier
> Still working well, no problems at all. Does slow down the Imail
> Administrator user listing but, I can easily live with that...
>
> ----- Original Message -----
> From: "Bruce Toogood" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 29, 2000 3:27 PM
> Subject: [IMail Forum] Robert, this was sent to the group earlier
>
>
> > I'm experiencing the exact same problems. I was in fact about to call
tech
> > support for about the third time. They seem to magically make it work
only
> > for it to die again for no apparent reason after a day or so (made it a
> week
> > once). What does the group think about using this new ODBCUSER.DLL
yet???
> >
> > Bruce
> >
> > ----- Original Message -----
> > From: Mike Nice <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, March 29, 2000 7:16 AM
> > Subject: RE: Re[2]: [IMail Forum] IMail w/SQL Database
> >
> >
> > > Wayne,
> > >
> > > We were infrequently hit with the problem at around 2,000 users so
> I've
> > > been looking into it. It turns out that how often the problem occurs
> > > depends on how evenly the users are distributed among virtual hosts.
It
> > > may also be less of a problem if the DB is on a remote PC because of
the
> > > network communications delay.
> > >
> > > According to the SQL server 7 online help, the SQL Server ODBC
driver
> > > supports only a single active statement per connection. I got around
> this
> > > by forcing a server side cursor. I have also posted this fix at
> > >
> > > http://home.att.net/~niceman/
> > >
> > > Note: although this appears to be a correct solution, it drops the
> > > performance of the IMail Administrator user list refresh by 1/2. So a
> > > couple thousand users may take 30 seconds to display on a single
> processor
> > > PC. It would take a redesign to explore other solutions such as mass
> > > query or a connection per query to see if those are faster.
> > >
> > > In <[EMAIL PROTECTED]>, on 01/01/00 at
> > > 12:00 AM,
> > > "Wayne Maw" <[EMAIL PROTECTED]> said:
> > >
> > > >not enough simultaneous pop3 sessions to cause the cursor problem.
> > >
> > > >(we hit the problem at 20,000+)
> > >
> > > >-----Original Message-----
> > > >From: [EMAIL PROTECTED]
> > > >[mailto:[EMAIL PROTECTED]]On Behalf Of GTOnline
> Support
> > > >Sent: 29 March 2000 13:48
> > > >To: Wayne Maw
> > > >Subject: Re[2]: [IMail Forum] IMail w/SQL Database
> > >
> > >
> > > >We may be an exception, we have Compaq Proliant 2 x 500Mhz Processor
> > > >Machines running IMail which in turn uses an SQL database on other
> > > >machines. We have had no problems in this area and have been running
> > > >since last October with 2500 accounts.
> > >
> > > >Wednesday, March 29, 2000, 10:06:09 AM, you wrote:
> > > >> If your using a machine with more than 1 processor, look elsewhere,
> > Imail
> > > >> don't work right with multiprocessor machines against SQL.
> > >
> > > >> And it keeps losing connectivity to DBase at least once a day.
> > >
> > > >> And they just ignore the fact.
> > >
> > >
> > >
> > > --
> > > -----------------------------------------------------------
> > > Mike Nice <[EMAIL PROTECTED]>
> > > -----------------------------------------------------------
> > >
> > > 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.
