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 <MLEBLMHHFOHFEPMAGJFBIEFACMAA.wamaw@callnetuk.com>, on 01/01/00 at 12:00 AM, "Wayne Maw" <wamaw@callnetuk.com> said:

>not enough simultaneous pop3 sessions to cause the cursor problem.

>(we hit the problem at 20,000+)

>-----Original Message----- >From: IMail_Forum-owner@list.ipswitch.com >[mailto:IMail_Forum-owner@list.ipswitch.com]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 <niceman@worldnet.att.net> -----------------------------------------------------------