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.
